gotornot Posted March 5, 2013 Share Posted March 5, 2013 Hi All I have a site that is takinga bunch of feeds from other sites, normalising the data into a product file. I also have a "Google" like search engine that a user can use to searh this data and get desired results. I have nearly 1m products and it takes 1 user only approximately 10 seconds to search the data even though its thoroughly indexed. I heard putting the data in cache would be far quicker. Is this true? The size of the data is just under 600mb so i have plenty of RAM. If this is true can someone please point me in the right direction to upload it in the cache and search on it. Many thanks Quote Link to comment https://forums.phpfreaks.com/topic/275265-php-mysql-cache-problems/ Share on other sites More sharing options...
AyKay47 Posted March 5, 2013 Share Posted March 5, 2013 Look into using memcache Quote Link to comment https://forums.phpfreaks.com/topic/275265-php-mysql-cache-problems/#findComment-1416813 Share on other sites More sharing options...
requinix Posted March 5, 2013 Share Posted March 5, 2013 There is memcache and there's memcached. memcached is the better one to use as it's more recent and supports more features. Quote Link to comment https://forums.phpfreaks.com/topic/275265-php-mysql-cache-problems/#findComment-1416827 Share on other sites More sharing options...
AyKay47 Posted March 5, 2013 Share Posted March 5, 2013 (edited) Edit: Nope you're right. Memcached is the newer client and should be used. Edited March 5, 2013 by AyKay47 Quote Link to comment https://forums.phpfreaks.com/topic/275265-php-mysql-cache-problems/#findComment-1416829 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.