Chad wrote: > On Sep 20, 2009 10:49 PM, "Tim Starling" <[email protected]> wrote: >> APseudoUtopia wrote: > I'm running MW 1.15.1. I'm having a problem with the >> Job Queue. I > noticed t... >> This is most likely due to a known bug in Special:Statistics, which >> causes it to give inaccurate numbers for the number of jobs remaining >> in the queue. You can get an accurate count by running an SQL query, >> say using phpMyAdmin: >> >> SELECT COUNT(*) FROM jobs; > > On that note, is there really any better way we could > do this? Right now if I'm remember correctly we check > the results of an EXPLAIN for an estimate. Is select > count(*) just impossibly slow, even if we cached the > result for an hour or whatever?
It's only slow if there are a large number of jobs. We could just do the EXPLAIN, and if it's less than say 10000, then we could follow it up with a COUNT(*) to get a more accurate result. -- Tim Starling _______________________________________________ MediaWiki-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
