Re: [PHP] Re: Left Join extremely slow (MySQL)

[William Poarch]

"explain"

 - - - - - - - - - -
 Scott Poarch
 www.globalhost.com
 - - - - - - - - - -

> From: "Richard Lynch" <[EMAIL PROTECTED]>
> Organization: Lynch Interplanetary Enterprises
> Date: Fri, 3 Aug 2001 17:09:49 -0500
> To: <[EMAIL PROTECTED]>
> Subject: [PHP] Re: Left Join extremely slow (MySQL)
> 
> Use MySQL's built in "analyze" ("describe"? SQL statement to see what's
> taking so long).
> 
> I'm betting on one server having an INDEX on the id or ex fields, and the
> other not.
> 
> --
> WARNING [EMAIL PROTECTED] address is an endangered species -- Use
> [EMAIL PROTECTED]
> Wanna help me out?  Like Music?  Buy a CD: http://l-i-e.com/artists.htm
> Volunteer a little time: http://chatmusic.com/volunteer.htm
> - Original Message -
> From: James Crowley <[EMAIL PROTECTED]>
> Newsgroups: php.general
> To: <[EMAIL PROTECTED]>
> Sent: Friday, August 03, 2001 11:40 AM
> Subject: Left Join extremely slow (MySQL)
> 
> 
>> Hi,
>> I had been using an INNER JOIN statement for a MySQL query, which
>> worked fine. However, my new ISP does not have the latest version of
>> MySQL. The version they have does not support conditions for Inner Join
>> statements, so I have tried switching to a Left Join instead. However,
>> the Left Join query takes 12.15 sec (which is obviously far too slow).
>> The Inner join statement, meanwhile, completed the query in 0.04. Any
>> idea why??
>> 
>> Here are the two statements (fast):
>> 
>> SELECT i.id, i.title, i.description FROM dir_items i INNER JOIN
>> dir_assoc a ON a.itemid=i.id WHERE a.parentid=59 AND a.ex=0
>> 
>> Here are the two statements (slow):
>> 
>> SELECT i.id, i.title, i.description FROM dir_items i LEFT JOIN dir_assoc
>> a ON a.itemid=i.id WHERE a.parentid=59 AND a.ex=0
>> 
>> Regards,
>> 
>> - James
>> 
>> Editor, VB Web
>> ==
>> Web   - http://www.vbweb.co.uk
>> Email - [EMAIL PROTECTED]
>> ICQ#  - 60612011
>> Fax   - +44(0)8707052859
>> ==
>> 
> 
> 
> -- 
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> 


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] PHP3

[William Poarch]

Hi,

Does "Select a.field, b.field from table_one a, table_two b where a.id =
b.id" work in PHP3/MySQL 3.22.32?

Client's running PHP3, and I'm on 4.

thanks.
 - - - - - - - - - -
 Scott Poarch
 www.globalhost.com
 - - - - - - - - - -


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Missing Records

[William Poarch]

Hi all,

I have a setup where I populate one table as a temporary holding place for data. When 
the user's session is complete, I want to transfer all that data to a similar, 
permanent table.

The strangeness is this - most of the time the data is all transferred fine, but 
sometimes only a few of the records will make it. If it always failed, I'd just figure 
the code was wonky, but becuase it gets through sporadically, I'm stumped. I'm 
guessing it has something to do with one mysql_query starting up before the previous 
one is finished. Help, please.

Here's the code:

for($counter = 1; $counter <=20; $counter++)
{
if($carray[$counter] != "" && $carray[$counter] != "0")
{
$sql = "SELECT * FROM feedback_results_temp where about_user_pkey = '$aboutradio' and 
by_user_pkey = '$user_pkeytemp' and competency_pkey = '$carray[$counter]'";
$result = mysql_query($sql);

$num = mysql_numrows($result);
if ($num != "0") 
{
$row=mysql_fetch_object($result);
$competency_pkey = $row->competency_pkey;
$rating = $row->rating;
$notes = $row->notes;

$sql_insert = "INSERT INTO feedback_results (about_user_pkey, by_user_pkey, 
competency_pkey, rating, date, notes) VALUES ('$aboutradio', '$user_pkeytemp', 
'$competency_pkey', '$rating', '$todaysdate', '$notes')";
$result_insert = mysql_query($sql_insert);
}
}
}

(After this, the code erases everything from feedback_results_temp)