SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-07-2008, 10:15 AM
| ||||
| ||||
 connectors: per session persistent connection (PHP) 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 or are there any other methods i am not aware of to achieve this? -- Sebastian Mendel      |
|
05-07-2008, 06:20 PM
| |||
| |||
| Re: connectors: per session persistent connection (PHP) This is a little off-topic for this list (recent PHP tutorials nowithstanding)... replying offline On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel <lists@sebastianmendel.de> 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 > > > or are there any other methods i am not aware of to achieve this? > > > -- > Sebastian Mendel > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com > > -- - michael dykman - mdykman@gmail.com - All models are wrong. Some models are useful. |
|
05-07-2008, 06:20 PM
| |||
| |||
| Re: connectors: per session persistent connection (PHP) isn't this the general mysql list? isn't mysqlnd maintained by mysql? Michael Dykman schrieb: > This is a little off-topic for this list (recent PHP tutorials > nowithstanding)... replying offline > On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel > <lists@sebastianmendel.de> 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 >> >> >> or are there any other methods i am not aware of to achieve this? |
|
05-07-2008, 06:20 PM
| |||
| |||
| Re: connectors: per session persistent connection (PHP) Yes, it is the generic MySQL list. Your question, I am suggesting, goes much more towards PHP interfaces and programming techniques rather than MySQL itself. You will find excellent mailing lists for PHP programmers who have spent a lot of time thinking about exactly this sort of problem. The behviour of apache-modules compiled from zend-provided source is not really a MySQL issue. On Wed, May 7, 2008 at 9:38 AM, Sebastian Mendel <lists@sebastianmendel.de> wrote: > > isn't this the general mysql list? isn't mysqlnd maintained by mysql? > > > Michael Dykman schrieb: > > > > > This is a little off-topic for this list (recent PHP tutorials > > nowithstanding)... replying offline > > On Wed, May 7, 2008 at 5:36 AM, Sebastian Mendel > > <lists@sebastianmendel.de> 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 > > > > > > > > > or are there any other methods i am not aware of to achieve this? > > > > > > > > -- - michael dykman - mdykman@gmail.com - All models are wrong. Some models are useful. |
|
05-10-2008, 02:03 PM
| |||
| |||
| Re: connectors: per session persistent connection (PHP) 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? -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com |
|
05-10-2008, 02:03 PM
| |||
| |||
| Re: connectors: per session persistent connection (PHP) 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? i do not talk of a global persistent connection, every session should have it's own persistent connection (if requested). -- Sebastian Mendel |
|
05-13-2008, 06:13 PM
| ||||
| ||||
| Re: connectors: per session persistent connection (PHP) 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 |
Linear Mode
