angelo
|
| Posted: 04/10/2002, 7:27 AM |
|
In codecharge next to the database connection there is a "persistent"
check box. Should this be ticked for Mysql databases or not? I've heard
conflicting advice on this. Some people say mysql is fast enough that it
doesn't require a persistent connection.
I'll be using my Code charge site on some high traffic situations, I'd
like to use the setting that uses the least amount of server resources.
thanks
Angelo
|
|
|
 |
RonB
|
| Posted: 04/11/2002, 9:14 AM |
|
"angelo" <nospam@spam.com> schreef in bericht
news:a91i3v$r9j$1@news.codecharge.com...
> In codecharge next to the database connection there is a "persistent"
> check box. Should this be ticked for Mysql databases or not? I've heard
> conflicting advice on this. Some people say mysql is fast enough that it
> doesn't require a persistent connection.
>
> I'll be using my Code charge site on some high traffic situations, I'd
> like to use the setting that uses the least amount of server resources.
>
> thanks
>
> Angelo
>
>
I think you should use persistent connections because it saves you the time
for creating a connection every time you want to query the database. With
MySQL this might not be a problem but with oracle it is because most of the
time while excecuting a query is used by creating a connection and believe
me oracle isn't that fast anyway.
RonB
|
|
|
|
|
