|
Some of your tables exceed the limit of 2 Gb or may exceed this limit in future, as FoxPro table size is (deliberately) limited to 2Gb.
On the other hand, if table size is about (but less than) 2Gb and there are a substantial number of simultaneous sessions, FoxPro productivity becomes inferior to that of SQL Server. This is the case when you really need some more complicated
technologies. If your network is slow or most operations are carried out at remote locations, you'll have to switch to Client-Server technology.
In this case we recommend that you should not waste your time and forget about FoxPro Automation and DBF. Such technology can be realized best with SQL Server or Oracle. Practice shows that only access to COM-objects (Automation servers) is slower than ODBC, let alone SQL Server productivity when it comes to large data
amounts.
Also, if you make distributed products, SQL Server compatibility will be one of the first evaluation
criteria. Another plus for SQL Server is its reliability (especially with indexes).
|
