>Hi,
>I have a general question concerning DBF size (bytes) and LAN performance. We have a table that is 80Mb (since system went live 1 year ago). We expect this dbf to more than double in size each year. (ie. next summer, this table will probably be 200mb+) There is also an FPT associated with this table that is currently over 8Mb.
>
>Should we be concerned with performance over time? Especially when issuing a USE command?
Just keep in mind that the larger a table gets, the more blatantly obvious any unoptimized code will become. VFP is very fast, even with large tables (80 MB is not large, IMHO). I don't think you will see a performance gain any time soon by switching to a server database.
Just make sure that all of your queries and LOCATES are fully optimizable, and you should be quite alright for some time to come.
Erik Moore
Clientelligence