Page 1 of 1
Really slow queries when joining
Posted: Mon Dec 17, 2007 12:21 am
by GeXus
I've been having really slow queries when doing joins.. specifically I'm joining to a highly transactional table - is it common to have slow queries in cases like that? All my indexes are setup properly as well.
Posted: Mon Dec 17, 2007 12:28 am
by John Cartwright
What does an EXPLAIN tell you?
Posted: Mon Dec 17, 2007 12:33 am
by Benjamin
What type of table is it? You may be having issues with it being locked as well.
Posted: Mon Dec 17, 2007 3:48 am
by CoderGoblin
Also are you returning just the information you want ? Using "SELECT *" often slows queries down considerably if there are a lot of columns involved.
Generally when asking questions like this it helps us to have more details such as an example to comment on.
Posted: Mon Dec 17, 2007 8:46 am
by chakhar86
Maybe you use non-integer primary/foreign key (or index) its dragging down performance of database.
Make sure you only use integer type for key field