+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: How to implement serialized searches like the CI forums uses? (/showthread.php?tid=12158)
How to implement serialized searches like the CI forums uses? - El Forum - 10-08-2008
[eluser]tinawina[/eluser]
I'm having a problem with my app running very slowly. (I posted a cry for help here maybe a week ago -- http://ellislab.com/forums/viewthread/92072/.) In a nutshell -- I have a search/browse application that requires a few MySQL and PHP hops before a query result list can be shown. Works great when you use it once or twice, but then it gets blocked up and any attempt to get new results can take minutes to load up on the page.
I tried out the database cache option and, while it solves the problem of the slow down, we use pagination and we show custom "You searched for X. There are X things to see." notices on result pages. These are completely wrong when I use database caching. Darn it!
So I was looking around again for an answer to this and ran into this post about serializing search results -- http://ellislab.com/forums/viewthread/45918. I'm particularly interested in what Rick Ellis wrote:
Quote:"Regarding caching search results. You'll likely want to cache the search query in your database and issue it an ID number so that you can generate results with pagination. If you search these forums you'll see such an ID in the URL."This seems to me to be the answer and I want to implement it -- but HOW? Appreciate any help as I'm pretty desperate to solve this already! THANKS!