Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
First query of view very slow
Message
From
24/09/2004 17:47:06
 
 
To
24/09/2004 14:53:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00945788
Message ID:
00945914
Views:
19
>> 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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform