Are you querying on indexed fields? That's the key to speed; check the 
MySQL docs on how it uses indexes. 20k records is not a large database.


At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote:
>We've been using MySQL for 2 years now in all the PHP systems we have 
>developed for our clients. We're thinking of using PostgreSQL now. What is 
>your experience with PostgreSQL? Any comments? The reason why we want to 
>shift is because we have encountered some problems with one of our 
>databases whose table contains more than 20K records. Somehow, it took so 
>long to query the database. Is PosgtreSQL a good substitute? We're 
>expecting a million records for our new project.
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to