Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Going slow with OleDbDataAdapter
Message
From
12/01/2005 09:45:38
 
 
To
11/01/2005 20:21:15
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
00976254
Message ID:
00976383
Views:
13
>I am using OleDbDataAdapter to extract data from Visual FoxPro. In the loop of getting all my messages, I am doing that about 20 times. So, the program now runs in 0.83 seconds instead of 0.2. Considering that this is a loop that will be executed 80 times, the droptime is big. What can I do to improve in that direction?

I'm not 100% clear on what you are doing. But, instead of making a query in the loop, can you query before the loop all the data you will need then you can just navigate in the data set within the loop. Or, is there too much data for this?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform