Search Suggestions using MySQL.
Posted: Tue May 29, 2007 9:01 pm
I'm actually making this with Flash but the communication link is through AMFPHP which is PHP based.
I run all the queries and stuff through PHP and thats all fine. The only question I have is about Caching MySQL results on the client side and performance.
I have it setup to query a database with LIMIT 10 every 1 second. I'm not sure how thats going to affect performance when, lets say, 5,000 people are using it at once. Can MySQL handle that just fine or am I going to run into some issues?
If I am, are there any suggestions you can offer to help on this one?
Would it be better to just put all the database suggestions into an array and search that? That would only bring up the issue of what happens when theres 10,000+ suggestions (Which there won't be in this case but I'd rather practice the right way then avoid learning it)
Any help?
I run all the queries and stuff through PHP and thats all fine. The only question I have is about Caching MySQL results on the client side and performance.
I have it setup to query a database with LIMIT 10 every 1 second. I'm not sure how thats going to affect performance when, lets say, 5,000 people are using it at once. Can MySQL handle that just fine or am I going to run into some issues?
If I am, are there any suggestions you can offer to help on this one?
Would it be better to just put all the database suggestions into an array and search that? That would only bring up the issue of what happens when theres 10,000+ suggestions (Which there won't be in this case but I'd rather practice the right way then avoid learning it)
Any help?