Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
5 years mysql experience but can't figure out good architecture...
I am wracking my brain trying to figure out the best way to design the database. The database will store real estate data. My biggest concern is speed of searching. Lets say I have a home which has 150 different attributes to it. Example attributes would be price, year built, square footage... -
Proper indexes used but query "Using temporary; Using filesort"
The query is complex and returns 16,000 out of 240,000 rows. Proper indexes are used and the query is relatively fast however it always uses temp tables and filesort. I am trying to speed it up though. When I do an explain I get... -
No index used for resultset of 819 rows from 4mil+ records?
Hello everyone, I am having a strange problem I cannot figure out... I have a table callled tracking_clickstreams: id - unsigned bigint primary key unique fkey_session - unsigned mediumint fkey_url - unsigned mediumint stamper - timestamp The table has an index on the id field, and a compound...
