Faqts : Computers : Programming : Shopping For You : PHP : Database Backed Sites : ODBC

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

7 of 27 people (26%) answered Yes
Recently 3 of 10 people (30%) answered Yes

Entry

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.