Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problems with optimizing query with IDX
Message
 
 
To
09/11/2006 09:10:57
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:
01168424
Views:
13
>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...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform