Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Attempting to optimize my app
Message
From
27/11/2005 09:59:23
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01072106
Message ID:
01072260
Views:
21
Sergey, Thanks for not giving up on me. I "get it".

As for the advice on adding a bunch of indexes indiscriminately, I will follow your advice of finding the slow ones and concentrating on those.

I estimate there are probably no more than 20 deleted records in all the tables in my application per installation. Deletes are seldom performed. I am going to hope that means I do not need any indexes on deleted(). If that is an incorrect assumption with regard to optimization please let me know.

Otherwise, I have learned a lot and I believe I have a good plan for going forward. Thanks all for the assistance.

John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform