PhP/MySQL Storing User Searches between Pages so the User Can Go Back to Them -
I am writing a php-mysql application, allowing the application to run a search against the database. When a search is run, the user clicks the returned item after checking the returned item, then they are asked if they want to send the query again (uses this post) which The search will be run again in the database, the use of receiving will not be in the request of a reporter - but still will run the search again.
Is there a way to archive and remember the search, again in the database?
This can save it to the database, or somehow in PHP - maybe with the session? There are lots of data coming out of these searches, I think that is probably too much for the session
In the second way I can imagine that it is to be stored in a database in some temporary table. The table that I intend to query, making the table with it, then choosing one to insert. Then select * from the table. It also sounds like a bad idea floating around the dynamically built floating tables.
I know that it can be done. What are the saved things that you see in many web applications, this is usually done?
or
However, I have noticed that you are not giving any reason why why you want to cache the results of the search "because it is fast, and I have read that it makes my app more scalable "The common reason for this is that it smells like a premonition adaptation.
I recommend that you build your application and create a profile. How expensive is these "searches"? Why are they expensive? Is this a bad schema design? Is this bad indexing? Is this a bad choice of storage engine?
Do you know that MySQL is a right one? In many cases it may just be all you need, try running your expensive "search" questions using MySql Client and note the time, then watch it run again?