Why wont this Query Work?

[anicolais]

I am having troubles connecting the custom contacts fields to the contacts fields. Here is the query I'm trying to run

select contacts_cstm.funnel_stage_c, contacts_cstm.funnel_description_c, contacts_cstm.funnel_date_c, contacts.first_name
from contacts_cstm, contacts
where contacts.ID = contacts_cstm.ID_c
and contacts_cstm.funnel_stage_c is not null
order by contacts_cstm.funnel_stage_c

Every time I try to run this the server times out. Is this a problem with my query or a problem on the hosting side?

MySQL
Sugar 5.5
Windows Vista

Thanks

[eggsurplus]

If you add a 'limit 1,10' at the end does it not time out? If it does return then either the result set is too large or there is a problem with your host or more likely a combination of both.

[kuske]

How many contacts records do you have?
How is your funnel_stage defined?
If it is a big charfield this can take a long time to sort.
You should create an index in contacts_cstm with id_c and funnale_stage_c.

I would add a

AND contacts.deleted=0

to read only non deleted records.

[wdroush]

What happens when you punch it directly into the mysql database's command line? That wont time out and give you a total processing time.


Also I'm picky

SELECT  contacts.first_name, contacts_cstm.funnel_stage_c, contacts_cstm.funnel_description_c, contacts_cstm.funnel_date_c
FROM contacts
LEFT JOIN contacts_cstm ON contacts_cstm.id_c=contacts.id
WHERE contacts_cstm.funnel_stage_c is not null AND contacts.deleted=0
ORDER BY contacts_cstm.funnel_stage_c