Hello.
Maybe you had configuration file with different settings. Nevertheless, send the information about your RAM size, the output of SHOW VARIABLES, configuration file, table definitions (use SHOW CREATE TABLE), EXPLAIN output for your query, and list should help you. Jeff Lacki <[EMAIL PROTECTED]> wrote: > > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
