My rule of thumb:

- the larger the table is
- the larger the .cdx is
- the smaller the pipe for reading (disk>LAN>WAN[phone]) is
- the more searching is done
- the less writing is needed
- if writing is done between reading (invalidating the cdx for rushmore)
- if seek/scan logic can be used instead of SQL or locate

compound keys will be more helpful.

HTH

thomas