Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limit to number of indexes
Message
General information
Forum:
Visual FoxPro
Category:
Installation, Setup and Configuration
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01195108
Message ID:
01195113
Views:
20
This message has been marked as a message which has helped to the initial question of the thread.
>Is there a limit to the number of indexes a table or cursor can have?
>
>I've been asked to build a search function for a table that will require 1,280 or more different indexes. Will I have to build standalone IDX files, or can VFP handle that number in a .CDX file?

You could go ahead (Help says it's limited by memory and available file handles), but be aware that you will experience a big slowdown in data handling (adding/deleting/updating).
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform