Re: [DB mysql]Multiple connection (bug 13232)
| From: | Tomas V.V.Cox | Date: | Sat, 05 Jan 2002 14:53:40 +0000 |
| Subject: | Re: [DB mysql]Multiple connection (bug 13232) | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-3785@lists.php.net to get a copy of this message | ||
Martin Jansen wrote:
>
> On Mon, 31 Dec 2001 20:01:36 +0100, Tomas V.V.Cox wrote:
>
> >Pierre-Alain Joye wrote:
> >> Sorry Tomas, I believe the bug 13232 is not fixed.
> >
> >I tried to avoid the mysql_select_db() before each query to speed up the
> >usual use with only one conection. Sadly this way definetly can't work
> >totally good, so I changed the behaviour to always "select" the database
> >before querying it.
>
> Do you have any results if this changes have a significant impact
> on performance?
>
Here are some numbers:
Now:
100 -> 0.263657
10000 -> 24.430398
Before:
100 -> 0.199539
10000 -> 20.296780
"100 ->" means inserting 100 records
(Note that the test box is a humble P233)
Tomas V.V.Cox