If it's a heavy use site you're create to not use persistent
connections. Otherwise everytime someone hits your webpage the connection
has to be recreated. This adds a LOT of overhead if you're sit is real busy.
At 04:57 PM 3/27/2001 -0800, Oson, Chris M. wrote:
>Mike,
>
>Excuse me if I'm wrong, but isn't using persistent connections more
>server resource intensive? I'm trying to optimize the database on
>a heavy site, and I decided not to use persistent connections.
>
>Chris
>
>-----Original Message-----
>From: Michael Betts [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, March 27, 2001 4:18 PM
>To: [EMAIL PROTECTED]; Steve Quezadas
>Subject: Re: MySQL vs MS-SQL performance
>
>
>Steve,
>
>I also experienced the same results you did until I realized that
>the MS-SQL connection was using pooled connections and my
>use of MySQL wasn't. After I started using persistent connections
>to MySQL, it was much faster than MS-SQL on identical hardware
>and no tuning on either system.
>
>Also if you are looking for a performance improvement, drop ODBC
>and try the native API; it's much faster.
>
>Mike
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Scott Baker - Webster Internet - Network Technician
503.266.8253 - [EMAIL PROTECTED]
"It has been said that the primary function of schools is to impart enough
facts to make children stop asking questions. Some, with whom the schools
do not succeed, become scientists." - Knut Schmidt-Nielson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php