how can i make this true - cache for mysql and php - Knowledgebase

Portal Home > Knowledgebase > Articles Database > how can i make this true - cache for mysql and php

how can i make this true - cache for mysql and php

Posted by aakram, 10-30-2008, 08:46 PM
how can i make this true - cache for mysql and php how can i make a cache for mysql and php for example i have a search engine and lets say someone search for linux and takes the search engine to find linnx 1 second and after like half an hour someone else come and searches for linux i dont want the search engine to go and look for it agean, i want it to give him the resultes from the old search thanks
Posted by techrammer, 11-01-2008, 01:49 AM
It may not be the exact solution you are looking for, though saving alot of PHP development and time, you could just enable query caching inside MySQL itself. Not an expert here though something like: query-cache-type = 1 And then some other variables to go along with it. Would likely improve performance in the scenario you describe and save you alot of work -Allan TechCrammer.com
Posted by jaseeey, 11-01-2008, 10:35 AM
Memcache might be of interest to you. However, it has to be optimised within the script (it has to be programmed to use it). It can be found here: http://au.php.net/memcache
Posted by Ogg, 11-11-2008, 11:36 AM
I'd give ADODB a look. It's an abstraction layer for PHP and MySQL.
Posted by apnicsolutions, 11-11-2008, 01:53 PM
aakram, read this: http://www.adamsinfo.com/php-mysql-a...wto-on-debian/ It details at the end exactly how to configure query caching for MySQL, and use and install eaccelerator for PHP. It speeds my stuff up incredibly __________________ Adam Palmer e: adam@adamsinfo.comwww.adamsinfo.com
Posted by coloheart, 11-18-2008, 01:48 PM
There can be numerous way to work with this...based on the search behanior of your users. We can store a few hundred popular searches and update those in a particular hour of the day. There can be other workarounds to improve the situation. PM me for any clarification.

Add to Favourites Print this Article