On Mon, July 24, 2006 1:33 pm, Ryan A wrote:
> Hey Rob,
> Thanks for replying.
>
>
>> It's usually a sign of poor programming and/or
>> purist OOP programming.
>>
>> When I say purist OOP programming...
>> I saw
>> one really retarded
>> implementation of this kind of system where an
>> excess of 2
On Mon, July 24, 2006 10:46 am, Ryan A wrote:
> This is not really a problem, more like a slightly OT
> question.
>
> Recently I have been testing some "CMS/carts/BB
> boards" and other related software, sometimes at the
> end of the page the software outputs the time it took
> to generate the page
--- "Kilbride, James P." <[EMAIL PROTECTED]>
wrote:
> While that kind of query structure can be a huge
> issue the biggest
> problem, and performance penalty, occurs if the
> programmer is opening
> and closing actual real connections. A good
> structure would use a
> singleton connection that i
On Mon, 2006-07-24 at 15:15, Kilbride, James P. wrote:
> While that kind of query structure can be a huge issue the biggest
> problem, and performance penalty, occurs if the programmer is opening
> and closing actual real connections. A good structure would use a
> singleton connection that is open
ts at once, using
cursors or partial retrievals instead and have to have multiple result
sets open at any given time).
James Kilbride
> -Original Message-
> From: Ryan A [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 24, 2006 2:34 PM
> To: Robert Cummings
> Cc: php php
>
Hey Rob,
Thanks for replying.
> It's usually a sign of poor programming and/or
> purist OOP programming.
>
> When I say purist OOP programming...
> I saw
> one really retarded
> implementation of this kind of system where an
> excess of 2 queries
> were issued to the database -- on a homepag
On Mon, 2006-07-24 at 11:46, Ryan A wrote:
> Hi,
>
> This is not really a problem, more like a slightly OT
> question.
>
> Recently I have been testing some "CMS/carts/BB
> boards" and other related software, sometimes at the
> end of the page the software outputs the time it took
> to generate t
On 4/1/06, Jim Lucas <[EMAIL PROTECTED]> wrote:
> Chris wrote:
> > Jasper Bryant-Greene wrote:
> >> Chris wrote:
> >>
> >>> If they're accessing the same database you don't need to
> >>> disconnect/reconnect. Different db's - well, yeh you don't have a
> >>> choice.
> >>
> >>
> >> Of course you do.
Chris wrote:
Jasper Bryant-Greene wrote:
Chris wrote:
If they're accessing the same database you don't need to
disconnect/reconnect. Different db's - well, yeh you don't have a
choice.
Of course you do. mysql_select_db() or whatever it's called. Or just
issue a USE [databasename] query. N
On 3/30/06, Chris <[EMAIL PROTECTED]> wrote:
>
> Jasper Bryant-Greene wrote:
> > Chris wrote:
> >
> >> If they're accessing the same database you don't need to
> >> disconnect/reconnect. Different db's - well, yeh you don't have a
> choice.
> >
> >
> > Of course you do. mysql_select_db() or whateve
Jasper Bryant-Greene wrote:
Chris wrote:
If they're accessing the same database you don't need to
disconnect/reconnect. Different db's - well, yeh you don't have a choice.
Of course you do. mysql_select_db() or whatever it's called. Or just
issue a USE [databasename] query. No need to recon
Chris wrote:
If they're accessing the same database you don't need to
disconnect/reconnect. Different db's - well, yeh you don't have a choice.
Of course you do. mysql_select_db() or whatever it's called. Or just
issue a USE [databasename] query. No need to reconnect!
--
Jasper Bryant-Greene
Hey all,
Thanks for replying.
/*
If you have phpmyadmin or something installed:
show status like '%connection%';
should show something.
*/Ok, will give that a shot./*If they're accessing the same database you
don't need to
disconnect/reconnect. Different db's - well, yeh you don't have a
choice.
Ryan A wrote:
Hi Phillip/Chris,
Thanks for replying.
Other than actually asking the host and taking a chance of pissing them off
before i have even done anythingis there any way to find out the max
connections by looking at the phpinfo() ?
If you have phpmyadmin or something installed:
sh
On Thu, 2006-03-30 at 19:31, Philip Hallstrom wrote:
> > I have almost finished making a set of scripts that would communicate with
> > maybe 1k sites to start with...
> >
> > I'm sorry I cannot give you more details about the scripts but this guy is
> > really nervious and had me sign an NDA etc e
Hi Phillip/Chris,
Thanks for replying.
Other than actually asking the host and taking a chance of pissing them off
before i have even done anythingis there any way to find out the max
connections by looking at the phpinfo() ?
/*
I hope you're not connecting/disconnecting between queries...
*
Ryan A wrote:
Hi,
I have almost finished making a set of scripts that would communicate with
maybe 1k sites to start with...
I'm sorry I cannot give you more details about the scripts but this guy is
really nervious and had me sign an NDA etc etc
but what i would like to know is; would there
I have almost finished making a set of scripts that would communicate with
maybe 1k sites to start with...
I'm sorry I cannot give you more details about the scripts but this guy is
really nervious and had me sign an NDA etc etc
but what i would like to know is; would there be a problem with con
You don't have to call mysql_close(). PHP handles cleaning resources when script
execution is ended.
You can set default connection parameters for MySQL in php.ini.
I don't know if you need to call mysql_connect(). (I don't use MySQL :)
Regards,
--
Yasuo Ohgaki
""David Hynes"" <[EMAIL PROTECTE
t;
> mOrP
>
> > -Original Message-
> > From: Ignacio Vazquez-Abrams [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 16, 2001 6:17 PM
> > To: Sam
> > Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> > Subject: Re: [PHP] Databas
s [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 6:17 PM
> To: Sam
> Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
> Subject: Re: [PHP] Database Connections - permanent or something else?
>
>
> On Tue, 16 Jan 2001, Sam wrote:
>
> > Hi,
On Tue, 16 Jan 2001, Sam wrote:
> Hi,
>
> I have several web pages that are built with php and mySQL.
> I use a new connection for each script.
> Should I be using a permanent connection? Or is there a better way around
> this?
>
> Regards,
> Sam Rose
>
Persistent connections are more efficient
22 matches
Mail list logo
