hello experts, i just want to know what is the best way to preform query with multiple table (2-3)
also, i read alot over the internet about the subject and some say subquery, some say join, so i want to know once and for all, witch case join is faster and witch case subquery is faseter. or there is only one that is the fastest..
i only care about the performance (cache, memory...), i don't care about how hard it is to read or if there is any logical in this, only preformance
basically i want to know in witch case who's better and if it has somthing with the database size, number of rows, engine. -> everything.. :)
i use MySQL database..
by the way, i use in my varchar variables in UTF-8 encoding and not ascii most of the time..
thanks agin :)