Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
First query of view very slow
Message
De
24/09/2004 17:47:06
 
 
À
24/09/2004 14:53:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00945788
Message ID:
00945914
Vues:
18
>> snipped

>If, first run, you execute this:
>
>SYS(3054,11)
>SELECT * FROM tacust WHERE tacust.cmrno = 0 AND tacust.actflag = "1"
>
>* or
>
>
>USE tacust .... ORDER cmrnoTAG
>COUNT
>SYS(3054,11)
>SELECT * FROM tacust WHERE tacust.cmrno = 0 AND tacust.actflag = "1"
>
>
>FABIO

Hello Fabio,

Thanks, I tried both (had to re-boot to try the 2nd one), it took ~3 minutes then 1-2 seconds after that, just like the view. Hmm...
Thanks!
~d
J
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform