| chadmaynard | whats a cannadick? |
| fraggeln | nevermind ;) |
| chadmaynard | oh come on can a dick? |
| haptiK | hello im having trouble with select distinct. im doing a performance report and whenever i use select distinct the searches take for ever and the mysql load goes through the roof |
| weigon | haptiK: paste the query at p.caboo.se and let's see |
| jeremy_g | chadmaynard:i dont need any help from lao tze. i know the journey of thousand miles begins with a single or small steps. haptiK:how many records you are querying over? |
| haptiK | jeremy_g: no more than about 5000 weigon: will do.. one sec. |
| chadmaynard | jeremy_g: i don't see how it applies |
| haptiK | http://p.caboo.se/53556 could it have something to do with the fact i haven't normalized the data for region or country for that matter. |
| chadmaynard | which part takes a long time? the select distinct or the order by? |
| haptiK | i'm not sure should i test that |
| weigon | haptiK: put an index on (country, region) ALTER TABLE mountains ADD INDEX (country, region); |
| haptiK | but you would suggest i normalize the data? a country table a region table ? |
| weigon | that's another story yes |
| haptiK | ok i am just new to mysql so i dont understand joins at all really im scared hehe |
| weigon | haptiK: hashmysql.org -> normalization |
| haptiK | ok thanks i must say you guys are much more helpful than #mysql on effnet i got banned yesterday for asking a mysql question efnet rather |
| action | chadmaynard bans haptiK for talking about mysql |
| chadmaynard | bans haptiK for talking about mysql |
| domas | yeah, we should ban people asking mysql questions here too |
| haptiK | haha |
| odb|fidel_ | hehe |
| chadmaynard | or just implement a random ban. |
| haptiK | there is one thing i am a little bit concerned about when i do this normalization thing |
| action | archivist bans chadmaynard |
| archivist | bans chadmaynard |