spaetz wrote the following on 03/12/2007 05:39: > On Sun, Dec 02, 2007 at 05:08:22PM +0100, J.D. Schmidt wrote: > >> http://tah.openstreetmap.org/Credits/ByUser/ is broken. No display of >> tiles, when inputting a user ID. >> >> Page used with user ID at every user from normal credits page. >> > Somebody had disabled it (not me). It absolutely killed performance as the > sorting by date was done in a filesort. > I reenabled the site, but disabled the sorting by date. This means it will > just display whatever mysql returns. It seems to be the most recents ones, > but that is just a mysql coincidence. > Could we add an additional 'where' clause to select only those tiles returned is the last 24hrs(or have the hours as parameter), remove the limit clause and then sort the result in php?
I'm happy to code something like this but I'm new to svn so what's the best way of being able to test my changes on the server before comitting them? Cheers rcr _______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/tilesathome
