I first came across this issue when I wrote a general
database backend in PHP-GTK (last year, around same time). I
had different objects on their own all with their own mysql
resource handle.
Now guess what, opening two connections with same
user/pass/host causes nearly unpredictable results because
the application was event driven and it was imposible to
foresee which DB was the current one. I would have to call
mysql_select_db() before _every_ query in the objects. This
was still solveable, but become a problem until the use could
freely type in sql statements (use other_db) so I wasn't able
to track which db should be the current one for the next call
(I could have parsed the SQL statement .. well).
I hope this gives a more real-world sample ... though I'm not
sure if it satisfies you. It describes my intention behind
this and is the last thing I could add to the thread.
- Markus
On Mon, Apr 22, 2002 at 05:42:02AM -0700, Rasmus Lerdorf wrote :
> I am not arguing against it, I have just not seen any decent technical
> reason to open two connections with the same credentials. Avoiding a
> mysql_select_db() call doesn't seem like a very good reason to me.
>
> -Rasmus
>
> On Mon, 22 Apr 2002, Markus Fischer wrote:
>
> > Rasmus,
> >
> > it has been desired by a few people including me to open
> > multiple connections to the same user/pass/host. If you do a
> > lot were you actually need it, and you forget to switch it one
> > time you can be in a lot trouble.
> >
> > Also, honestly, I do not understand why PHP _forces_ you to
> > reuse the same links. Until the patch/optional parameter the
> > only workaround was to use another username (doh!).
> >
> > I already talked to Yasou and he ensured me he will implement
> > a similar facility to pgsql extension (as much tied to mysql
> > as possible to be not too different). I've seen other native
> > DB drivers seem to 'suffer' from the same feature.
> >
> > This feature on its own is good for new users. But until
> > recently it didn't gave a, let's say a more expirienced user
> > knowing what she does, the ability to solve from PHP side
> > (which is exactly what people complained; here on php-dev@
> > and also on pear-dev@).
> >
> > my 2eurocents
> >
> > - Markus
> >
> > On Mon, Apr 22, 2002 at 04:53:22AM -0700, Rasmus Lerdorf wrote :
> > > Just curious, why do you need multiple identical connections?
> > >
> > > On Mon, 22 Apr 2002, Matthew Walker wrote:
> > >
> > > > Ahhh. Delighted to hear that. I'll upgrade as soon as there's an RPM
> > > > available for RH7.1. (I'd compile it, but I always forget something, and
> > > > I can't afford downtime on that server.)
> > > >
> > > > Thanks for everyone's help. May I never need it again. (I only mail
> > > > developers when it's a /major issue.)
> > > >
> > > > Matthew Walker
> > > > Senior Software Engineer
> > > > ePliant Marketing
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Markus Fischer [mailto:[EMAIL PROTECTED]]
> > > > Sent: Monday, April 22, 2002 6:50 AM
> > > > To: Matthew Walker
> > > > Cc: [EMAIL PROTECTED]
> > > > Subject: Re: [PHP-DEV] Major Bug in multiple MySQL Connections?
> > > >
> > > > Hello Matthew,
> > > >
> > > > you should read my commect on this bug report too. 4.2.0
> > > > which will be released soon contains already a workaround for
> > > > this limitation.
> > > >
> > > > - Markus
> > > >
> > > > On Mon, Apr 22, 2002 at 06:41:44AM -0600, Matthew Walker wrote :
> > > > > I believe I may have found a major bug in the use of multiple MySQL
> > > > > connections. Please see my bug report at HYPERLINK
> > > > >
> > > > "http://bugs.php.net/bug.php?id=16730"http://bugs.php.net/bug.php?id=167
> > > > > 30. If I?m wrong about this, please tell me how to fix it. This is a
> > > > > showstopper bug for the software I?m currently working on.
> > > > >
> > > > > Matthew Walker
> > > > > Senior Software Engineer
> > > > > ePliant Marketing
> > > > >
> > > > >
> > > > > ---
> > > > > Outgoing mail is certified Virus Free.
> > > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > > Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002
> > > > >
> > > > >
> > > > > --
> > > > > PHP Development Mailing List <http://www.php.net/>
> > > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > > > --
> > > > Please always Cc to me when replying to me on the lists.
> > > > GnuPG Key: http://guru.josefine.at/~mfischer/C2272BD0.asc
> > > > "Mind if I MFH ?" "What QA did you do on it?" "the usual?" "ah... none
> > > > :)"
> > > >
> > > >
> > > > ---
> > > > Outgoing mail is certified Virus Free.
> > > > Checked by AVG anti-virus system (http://www.grisoft.com).
> > > > Version: 6.0.345 / Virus Database: 193 - Release Date: 4/9/2002
> > > >
> > > >
> > > > --
> > > > PHP Development Mailing List <http://www.php.net/>
> > > > To unsubscribe, visit: http://www.php.net/unsub.php
> > > >
> > >
> > >
> > > --
> > > PHP Development Mailing List <http://www.php.net/>
> > > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> > --
> > Please always Cc to me when replying to me on the lists.
> > GnuPG Key: http://guru.josefine.at/~mfischer/C2272BD0.asc
> > "Mind if I MFH ?" "What QA did you do on it?" "the usual?" "ah... none :)"
> >
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Please always Cc to me when replying to me on the lists.
GnuPG Key: http://guru.josefine.at/~mfischer/C2272BD0.asc
"Mind if I MFH ?" "What QA did you do on it?" "the usual?" "ah... none :)"
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, visit: http://www.php.net/unsub.php
