i have a sync script that queries several different wordpress databases every 15 minutes to keep a main "feed" table up to date. it totals approximately 50,000 queries (99% of them are Selects, for meta, etc)... it takes approximately 10 seconds to run these queries every 15 minutes. is this a bad idea or will it not bother performance too much to do that many selects?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
closed as not a real question by Mark Storey-Smith, Leigh Riffel, RolandoMySQLDBA, dezso, JNK♦ Feb 22 at 13:46
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, see the FAQ.