469,088 Members | 1,242 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

Query with 3.3million rows is slow?

I'm not that great with MySQL...so I was hoping someone could help me out.
The query I'm running is too slow...can anyone tell me what I can do to
speed it up..if I can at all? I was wondering if because ZipListMatrix has
3.3 million rows that 8 seconds is all the faster it's going to be. Any
help is greatly appreciated! I have already "optimized" the tables.

ZipListMatrix.ZipListMatrixID, ZipListMatrix.ZipID,
ZipListMatrix.CarrierRouteID, ZipListMatrix.ListID, ZipListMatrix.Quantity,
List.DisplayOrder
FROM ZipListMatrix
JOIN List
JOIN UserList ON List.ListID = UserList.ListID ON ZipListMatrix.ListID =
List.ListID
WHERE UserList.UserInfoID = 869 AND ZipListMatrix.ZipID = 23112
ORDER BY ZipListMatrix.ZipID, ZipListMatrix.CarrierRouteID,
ZipListMatrix.ListID

the explain:
UserList - ref ListID,UserInfoID - UserInfoID - 5 - const - 3 - Using
where; Using temporary; Using filesort
List - eq_ref - PRIMARY,ListID - PRIMARY - 10 - UserList.ListID - 1
ZipListMatrix - ref - ListID,ZipID - ListID - 11 - List.ListID - 105509 -
Using where

TIA
-bruce duncan
Jul 20 '05 #1
0 1203

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jesse Sheidlower | last post: by
2 posts views Thread by Yonatan Goraly | last post: by
16 posts views Thread by Dave Weaver | last post: by
reply views Thread by rdnews | last post: by
1 post views Thread by Generale Cluster | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.