Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What was the developer thinking?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01412303
Message ID:
01412436
Views:
79
Hi Nicholas,

>BTW I just checked. One table in this system has 59 indexes.

The project I'm working on had close to 100 in one table before we started optimizing them away. <g> The number of indexed affected the time it took to run the form, because every tag results in a 4 KB block that needs to be read when the table is opened for the first time.
--
Christof
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform