Re: [PHP] mssql_* overhead

2007-01-11 Thread Sancar Saran
On Wednesday 10 January 2007 17:47, Philip Thompson wrote: > Hi. > > Does anyone know if the mssql_connect/_init/_bind/etc require a lot > of overhead? > > I have a page that requires multiple function calls and each of those > opens a new connection to the database, performs the necessary > action

RE: [PHP] mssql_* overhead

2007-01-10 Thread bruce
t' Subject: Re: [PHP] mssql_* overhead bruce wrote: > hi phillip... > > just to clarify regarding having the mysql resource ID in a session var. are > you saying that you're able to more or less, do a mysql_connect and store > the resourceID in a session var, which can then

Re: [PHP] mssql_* overhead

2007-01-10 Thread Chris
bruce wrote: hi phillip... just to clarify regarding having the mysql resource ID in a session var. are you saying that you're able to more or less, do a mysql_connect and store the resourceID in a session var, which can then be used on any given page within your site, without having to recall t

Re: [PHP] mssql_* overhead

2007-01-10 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2007-01-10 10:49:35 -0600: > On Jan 10, 2007, at 10:09 AM, Jochem Maas wrote: > >Philip Thompson wrote: > >>Does anyone know if the mssql_connect/_init/_bind/etc require a > >>lot of overhead? You can quite easily find out what effect those function have on the performance

RE: [PHP] mssql_* overhead

2007-01-10 Thread bruce
EMAIL PROTECTED] Sent: Wednesday, January 10, 2007 9:28 AM To: php General List Subject: Re: [PHP] mssql_* overhead I just wanted to make sure that there is no speed decrease if I change from $_SESSION to $GLOBALS to hold my connection (even with lots of people). I guess that's my question? Thank

Re: [PHP] mssql_* overhead

2007-01-10 Thread Philip Thompson
Ok, just kidding. Thank you Jim and Jochem. You answered my question in your previous posts! Thanks to all! ~Phil On Jan 10, 2007, at 11:27 AM, Philip Thompson wrote: I just wanted to make sure that there is no speed decrease if I change from $_SESSION to $GLOBALS to hold my connection (ev

Re: [PHP] mssql_* overhead

2007-01-10 Thread Philip Thompson
I just wanted to make sure that there is no speed decrease if I change from $_SESSION to $GLOBALS to hold my connection (even with lots of people). I guess that's my question? Thanks, ~Philip On Jan 10, 2007, at 11:01 AM, [EMAIL PROTECTED] wrote: I thought the same thing as Jochem... that

Re: [PHP] mssql_* overhead

2007-01-10 Thread Jochem Maas
Philip Thompson wrote: > On Jan 10, 2007, at 10:09 AM, Jochem Maas wrote: > >> Philip Thompson wrote: >>> Hi. >>> >>> Does anyone know if the mssql_connect/_init/_bind/etc require a lot of >>> overhead? >>> >>> I have a page that requires multiple function calls and each of those >>> opens a new c

Re: [PHP] mssql_* overhead

2007-01-10 Thread Jim Lucas
Philip Thompson wrote: On Jan 10, 2007, at 10:09 AM, Jochem Maas wrote: Philip Thompson wrote: Hi. Does anyone know if the mssql_connect/_init/_bind/etc require a lot of overhead? I have a page that requires multiple function calls and each of those opens a new connection to the database, pe

Re: [PHP] mssql_* overhead

2007-01-10 Thread tg-php
I thought the same thing as Jochem... that resources like database connections, couldn't be stored in $_SESSION. You say that's how you have (had?) it set up and it was working, but still sounds wrong to me. As for connections.. definitely don't open a new connection every time you run a functi

Re: [PHP] mssql_* overhead

2007-01-10 Thread Eric Butera
On 1/10/07, Philip Thompson <[EMAIL PROTECTED]> wrote: On Jan 10, 2007, at 10:09 AM, Jochem Maas wrote: > Philip Thompson wrote: >> Hi. >> >> Does anyone know if the mssql_connect/_init/_bind/etc require a >> lot of >> overhead? >> >> I have a page that requires multiple function calls and each

Re: [PHP] mssql_* overhead

2007-01-10 Thread Philip Thompson
On Jan 10, 2007, at 10:09 AM, Jochem Maas wrote: Philip Thompson wrote: Hi. Does anyone know if the mssql_connect/_init/_bind/etc require a lot of overhead? I have a page that requires multiple function calls and each of those opens a new connection to the database, performs the necessary

Re: [PHP] mssql_* overhead

2007-01-10 Thread Jochem Maas
Philip Thompson wrote: > Hi. > > Does anyone know if the mssql_connect/_init/_bind/etc require a lot of > overhead? > > I have a page that requires multiple function calls and each of those > opens a new connection to the database, performs the necessary actions > in stored procedure(s), and then