Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL speed difference
Message
 
À
12/08/1997 05:26:40
Siu-Hung Lai
The Hong Kong University of Sci. & Tech.
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00044159
Message ID:
00044348
Vues:
26
>I have 6 SQL command in a prg to retrive data into a cursor from 3 tables(with 9000,180,000 and 340,000 records). When I run the prg from project manager, it takes 37 secs. If I run it in the Form.Load(), it takes 60 secs. What is the possible cause?
>
>TIA
>
>S H

some settings like SET DELETED ON/OFF can have an influence, if you don't have an index on DELETED()
Just a guess.

Christian
Christian Desbourse ( Belgium )
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform