Hello- I have a user list of about 200 entries
My original config was Fedora Core 3, Mysql 3.23 I upgraded today to Fedora Core 4 which comes with MySQL 4.12. AFter updating all the packages etc and setting up the website I run again, I notice that I had slow query's during searches. More investigation revealed that I can reproduce this in the mysql> command mode as well. If I do a long SELECT query (multiple columns across 3 tables), the query can take 20-30 seconds. If I reduce the number of columns in that SELECT statement, the speed increases. I would expect this anyhow, however in 3.23 I had NO hesitation at all and the result set came immediately back to me. Ive read through the upgrade web pagess on the mysql site and did what needed to be done (which wasnt much to begin with) and result is the same. here's my select statement: SELECT userid, nickname, city, state, country, email, sex, birthday, marital_stat, num_children, height, weight, smoke, drink, image1, description, age_range_min, age_range_max, is_active FROM users1, user_stats1, user_wants1, user_account1 WHERE sex='m' AND userid=user_stats1.id AND userid=user_wants1.id AND userid=user_account1.id order by sex LIMIT 200 Any ideas/help is much appreciated. Im a relative newbie to mysql and databases in general. Jeff -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
