Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOleDb.1, the day after
Message
From
08/10/2006 06:33:54
 
 
To
07/10/2006 16:43:43
General information
Forum:
ASP.NET
Category:
Databases
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01160349
Message ID:
01160382
Views:
15
>When I run my test today, I sent 600 hits in two minutes. I sent the test against a production page which is one of the busiest of the site. That page processes about 25 SQL commands. Within that timeframe, I got 16 errors. All the errors reported were all related to that problem. But, on all those errors, the HTML code for the page was returned ok.
>
You might think about checking another angle: from the above you have approx. 0.1% error on all SQL commands (16 errors on 600 * 25 SQL), so the probability of having the SQL error out again is at every thousandth error. Running the test for an hour should give you about 500 errors or a 50% chance of having the same SQL fail twice in a row. If you run your test for a few days on a dedicated machine you could make sure if the error always occured on the first SQL or if it occurs in the same percentage of "first errors". (Hypothesis: some trouble while creating/initializing).

regards

thomas
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform