On May 9, 2008, at 12:17 AM, Sebastian Mendel wrote:
Paul DuBois schrieb:
On May 7, 2008, at 4:36 AM, Sebastian Mendel wrote:
Hi,
wouldn't it be very helpful if mysql connectors support some sort
of per session persistent connection?
this would save a lot of queries in many apps, for example SET
NAMES, setting variables, creating temporary tables
How would a persistent connection save any of that?
Suppose the script that previously used the connection reset any or
all of those things?
i do not fully understand, why should the script reset these things?
It doesn't have to reset any of those things, but you are *assuming*
that no other script *will* reset any of those things. As far as I
understand what you want to do, that's an invalid assumption. How
do you know what some other script might want to do? Perhaps it wants
a different character set than you do.
i do not talk of a global persistent connection, every session
should have it's own persistent connection (if requested).
A session is a connection. When the connection ends, the session ends.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
