I am writing a search plugin for the MySite module, which displays content in MyYahoo! style link clusters.<br><br>The requirement is that user be able to save searches to their MySite page. This requirement means that multiple searches might be requested when loading a MySite page.
<br><br>The core search function do_search() creates temporary tables to store data and assumes that only one search will be run per page load.<br><br>As a result, trying to execute do_search() more than once per page view throws SQL errors.
<br><br>I have described the issue in greater detail here:<br><br><a href="http://drupal.org/node/102219">http://drupal.org/node/102219</a><br><br>I am definitely not suggesting that temporary tables be removed from core. I am simply looking for a good solution to my issue.
<br><br>I would appreciate feedback on the issue, rather than the list.<br><br>Thanks,<br><br>Ken Rickard<br>agentrickard<br>