It’s time for my 6 monthly rewrite for my dating site. I feel I’ve really gone to town this time π Not only have I flattened loads of bugs, I’ve redesigned the look and even gone to the expense of commisioning some artwork.
I’ve also rewritten loads of the database queries as I’m now using MySQL 4.1.x – my old host (yes I’ve changed hosting providers as well) was on 4.0.x and didn’t have any plans to upgrade when I asked them a few months back, so now I can use sub queries π
Now all I need is a ton of traffic. Let me know what you think of my updated lonely hearts personals site
Very cheezy β fits well! Watch out for your character sets ma boy, since βοΏ½β generally means something couldn’t be converted. I can give examples but I won’t here.
Sub-queries are evil, so be careful. I’m not sure about MySQL’s implementation, but there’s a very high chance that they will cause several βinnerβ result sets to be created for every real row you return. Personally I haven’t hit a problem that required sub-queries because joins wouldn’t work, nor have I ever seen sub-queries used in a query that can outperform its equivalent using real joins.
Prove me wrong! π
Comment by Simon Butcher — September 11, 2007 @ 5:21 pm
Actually, wait, hold onβ¦ Aren’t you supposed to be in Italy?
Comment by Simon Butcher — September 11, 2007 @ 5:27 pm
Decided to go to Orlando instead at the last minute. Thanks for the comments – I’ll investigate the evil sub queries further I think
Comment by Brew — September 18, 2007 @ 11:15 am