"Peter Gervai" <grin(a)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
--
| ,__o
| _-\_<,
http://www.gnu.franken.de/ke/ | (*)/'(*)