In my tag synonyms plugin, when you edit tags it seems to take a very long time to retag questions. I am running a new query on every question to save it back to the database, which I don't think I can avoid.
But I also think I'm doing too much when selecting every tag initially. Here is the current code, which runs for each tag synonym to grab questions with the old tags:
$questions = qa_db_select_with_pending(
qa_db_tag_recent_qs_selectspec( null, $syn['from'], 0, false, 500 )
The qa_db_select_with_pending function apparently selects a bunch of other stuff like options, which I don't need - not 10+ times anyway! Is there a better way to simply select all the questions with a particular tag?