Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Going slow with OleDbDataAdapter
Message
De
12/01/2005 09:45:38
 
 
À
11/01/2005 20:21:15
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
00976254
Message ID:
00976383
Vues:
12
>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?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform