"Peter Gervai" grin@grin.hu writes:
Well, you can usually only gain speed by using more space for auxilary tables. I do not believe in that hardware upgrade is the solution for lack of design. :-]
I've the feeling you are not wrong.
For the moment, my idea is: the user should be allowed to fetch his list once a day. If that's still to expensive simplify the layout or contents of the watchlist - don't generate diff and version links (I am able to do the diff locally). Or prepare user watch lists once a day and let the user download this daily list. Without watchlists working on the project isn't that much fun...
And switch to PostgreSQL. PostgreSQL obeys the SQL standard much better and thus it is more likely to attract SQL developers