• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Caching on a Shared Host

S

Stiganator

Platinum Member
I am developing a housing search application. I know that many shared hosting will cut you off if you go over CPU threshhold. Is the proper way to get around that to cache every possible search combination like twice a day so you can just send them a pre-queried list?
 
If your queries are causing your CPU usage to be that high, I would first look at why your queries are taking so long. They could be rewritten for better performance.

Back to your original question, you could create a table for each query combination to store your results and then schedule your tables to updated twice a day. Then your application just needs to query the correct table based on the query combination.

techfuzz
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top