Quote:
Originally posted by Apache_A
oh and number 3 is the most bonkers thing I've ever seen in relation to databases'
|
hehe yeah...I never sued it, but thought it up as a possibility. Since the version I'm using of MySQL doesn't support sub-selects, I figured it might be faster to select the combination id from that table, then use it in my select from the big table instead of doing any complicated join queries.
There are some cases I've had where doing one mini-select and then another select comes out faster than doing a complicated JOIN query.
NUmber 4 I can see it being the most standardized...however if I don't have sub-selects, I think it might be worse than the set method...
Thanks for your input =)