On Wed, Oct 9, 2013 at 2:09 AM, Aaron Schulz aschulz4587@gmail.com wrote:
They often give the same results on smallish wikis, but I wouldn't carry that over to test wikis unless lots of content and users, logging, other table data was somehow imported in. For example a tiny user table might make mysql start INNER JOINs with that table in queries where it would never do that in production. In my experience development test wikis are often useless for estimating what query plan will happen in production.
This has been my experience as well. Using my test wiki is pretty much useless.
A smallish wiki with 10ks of pages and the full history and the table data
(not just revision/page/*links stuff from dumps) would probably be useful. I'm not sure where the threshold roughly starts though.
OK, maybe I'll try this then. Thanks for the advice.
*-- * *Tyler Romeo* Stevens Institute of Technology, Class of 2016 Major in Computer Science