From: "Dan Anderson" <[EMAIL PROTECTED]>
> > While multiple connections will just return the first connection,
anyhow,
> > why do the extra work, right?
>
> Yes that was what I was thinking. But I was also thinking that I would
> need to global the $link and $db variables and run mysql_query() w
> While multiple connections will just return the first connection, anyhow,
> why do the extra work, right?
Yes that was what I was thinking. But I was also thinking that I would
need to global the $link and $db variables and run mysql_query() with
them in options. So I'm wondering how much work
From: "Dan Anderson" <[EMAIL PROTECTED]>
> But how much overhead is there in:
>
> $link = mysql_connect($hostname,$username,$password) or die("");
> $db = mysql_select_db($database,$link) or die("");
>
> Would it be beneficial to run a single one at the beginning of every
> script? Currently I hav
--- Dan Anderson <[EMAIL PROTECTED]> wrote:
> I've figured out that all mySQL queries should use indexed ids for
> speed. (For anyone who doesn't know: mySQL indexes fields with ...
You can create an index yourself:
KEY [index_name] (index_col_name,...)
Find more on this page:
http://www.mysql
check this out dan
It may help
http://www.mysql.com/doc/en/EXPLAIN.html
- Original Message -
From: "Dan Anderson" <[EMAIL PROTECTED]>
To: "PHP List" <[EMAIL PROTECTED]>
Sent: Friday, September 05, 2003 8:38 AM
Subject: [PHP] mySQL overhead: Tweaking Scripts for Speed
> I'm trying to
5 matches
Mail list logo
