Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible causes of slow query
Message
From
01/03/1999 18:58:10
Dave Nantais
Light speed database solutions
Ontario, Canada
 
 
To
26/02/1999 17:09:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00192035
Message ID:
00192932
Views:
24
>Hi Evan,
>
>This at leasts suggests strongly that it is not the network.
>
>The users I've had would never put up with 6-7 seconds for the type of example you give, and this even against a near 2-gig table with over 1.3 million records and a whole lot of indexes defined (though it was in 2.6).

are you saying indexes in 2.6 are not as good as indexes in 3,5,6 and later
(in terms of speed of access using SEEK on an indexed field) ?

i use 2 gig look up tables and i am trying to convince my boss to redo
all of our old apps in VFP ... right now we keep them in the old dbf format

any info is appreciated,
DAve.

>
>I would still say that something is amiss, though I am at a loss as to exactly what.
>
>Good luck,
>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform