Re: Hi and thanks
| From: | Richard Lynch | Date: | Thu, 04 Jan 2001 22:00:49 +0000 |
| Subject: | Re: Hi and thanks | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-32744@lists.php.net to get a copy of this message | ||
> It has a few problems such as it seems a bit slow and it gets some mysql
> access errors due to something. It just can't open the db fast enough for
> the users (only about 200 total so far and growing exponentially). I
think
> the db needs some indexes etc. Hopefully I will figure them out soon.
Indices will speed up individual queries, but will do *nothing* to speed up
mysql_connect.
The only way to speed up mysql_connect is to use mysql_pconnect, or buy a
(much) faster network interface.