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 and the
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 queries
were
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 the page and the number of database calls.
I have seen some
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 the page
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 homepage
, 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
Subject: Re: [PHP] database
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 opened
--- 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 is opened
Hey all,
Ok, spoke to the boss and he has agreed for me to give you the following
info;
Heres what the app does:
- Clients add their sites in their client control panel which we give them
at our site
- Client installs our script on his server, every time someone logs in their
username is sent to
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.
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. mysql_select_db() or whatever
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 be a problem
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
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
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...
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 etc
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:
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
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
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
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 whatever it's called. Or
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
I'm using PHP on a windows box to access a MySQL database.
I noticed that I do not need to open a database connection before performing
a mysql_db_query(). Is this bad coding ? Should the database connection
always be made ? Is this specific to Windows ?
# $databaseConnection = mysql_connect
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
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 in that
: Ignacio Vazquez-Abrams [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,
I have several web pages
26 matches
Mail list logo
