Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with optimizing query with IDX
Message
From
09/11/2006 09:34:26
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01168352
Message ID:
01168427
Views:
16
>>No, I overlooked that, sorry! I actually browsed through the code, but I obviously was not quite awake! :-)
>>
>>BTW, have you tried to make a copy of the tables for testing, and create CDX tags in stead of the IDXs for these copies? I mean, just to try if the speed is more or less the same, or substantially faster?
>>
>
>Not, I haven't yet tried. I think I'll make a local copy of these three tables involved and make a test, but unfortunately it would not help much since the data tables are on the Network and they use IDX indexes...

I understand that it will not help directly, but if the select gets much fasted with CDXs, at least you know where you shall focus your tests, so to say.
Previous
Reply
Map
View

Click here to load this message in the networking platform