Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance issues when querying shared data
Message
 
To
07/10/2005 09:56:13
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 6
Miscellaneous
Thread ID:
01057091
Message ID:
01057170
Views:
13
Well,

The initial query is:

Select a.field1 As Code, a.Field2 As Desc From TableA a Into Cursor tmpCursor

The table has an index on field1 so I added:

where a.Field1 = ""

It's a cheat I know but the query is optimised and works as long as set exact off.

The time jumps from 5 secs to under 2.

Regards
>>Hi Mike,
>>
>>Yes I can and I have by introducing a dummy where clause. It optimises and halves the time roughly 2 seconds.
>>
>
>Hi Mathias,
>
>Can you expand a little on this "dummy where clause" idea?
>
>Regards,
Mathias Banda

Time is longer than a rope.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform