>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only