Lester,
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.
Miles
At 04:06 PM 8/24/01 +0800, Lester June Cabrera wrote:
>Hi,
>
>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.
>
>
>Thanks,
>Lester
>
>
>--
>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]