Page 1 of 1

PHP Search Results Cache

Posted: Wed Dec 15, 2010 12:33 am
by matts12290
Hello - I have a live search that queries the database right now on every keystroke to get results of matches of the text input (like the facebook search but with my database). I was wondering if anyone knew what would be best to prevent so many database calls. Maybe storing everything to an xml file on the server? Running a cron job to write to that xml file? The search script is being called via ajax to show dynamically. If anyone has any tips they would be appreciated :)

Thanks!