Re: [PHP] mySQL table joins are slow, need rebuild?

It also seems you have a semicolon in your query, mysql_query() specifically states not to have on at the end of your queries, so I am guessing this may be a factor... Steve Joe Stump wrote: You need to remember a few things when it comes to joins: the joined fields must be the EXACT same

[PHP] mySQL table joins are slow, need rebuild?

hi, i have a query that is comparing a table with 1235 rows with another that has 635 rows. The query looks like this: $res = mysql_query("select cust_info.ID, cust_info.first_name, cust_info.last_name, cust_info.address, cust_info.datestamp from cust_info, cust_order_info where

Re: [PHP] mySQL table joins are slow, need rebuild?

You need to remember a few things when it comes to joins: the joined fields must be the EXACT same definition - example: a join on id int(9) and id int(3) will NOT be optimized - more: a join on id char(9) and id int(9) is REALLY NOT optimized :O) We have an accounts table with

Re: [PHP] mySQL table joins are slow, need rebuild?

On Tue, 27 Feb 2001 15:04:09 -0800, Joe Stump ([EMAIL PROTECTED]) wrote: You need to remember a few things when it comes to joins: the joined fields must be the EXACT same definition - example: a join on id int(9) and id int(3) will NOT be optimized - more: a join on id char(9) and