Results 1 to 2 of 2
Thread: joins causing slow downs?
Jan 6, 2002, 20:39 #1
joins causing slow downs?
I have been noticing a slow down in mysql when using joins to select data... is it just me or is it a problem??i dunno...
Jan 6, 2002, 20:43 #2
- Join Date
- Jul 2001
- 0 Post(s)
- 0 Thread(s)
i'd have to see your table layout (either your CREATE TABLE statements or "DESCRIBE table") and an example of a slow query. how slow are they? if your tables are properly indexed, there shouldn't be much slowdown at all, even when joining a lot of tables. that's what it comes down to -- do you have the tables properly indexed for each query?
always use "EXPLAIN query" to see how indexes are being used for each table.- Matt ** Ignore old signature for now... **
Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
"Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR