Reason for poor performance of a PHP-Application working with ODBC and MS-Access 7.0
Sep 16th, 2000 23:37
John Lim, Sylvester Burckhardt,
Without some idea of the database size, some benchmarks or source code,
it is hard to judge the actual reason for the poor performance. Try
compacting the database, and try to make use of indices in your queries.
But in general, Microsoft Access is the slowest database product from
Microsoft. For a low-cost faster solution, use FoxPro tables (up to
100% faster). For higher performance, use MySQL, Oracle, MS SQL server
or a similar database.