Hi all, I am investigating the use of data caching at the moment and was digging around this google group. I found some very interesting posts on how to optimize cake but no satisfactory answer to "when should I actually use a file cache for my data".
I took over a website which uses data caching heavily, but the queries are actually pretty straight forward with just one joint. Nothing too recursive. The previous developer cached all that data using the cake file cache method. I'm not the database expert but I know that most queries are chached in MySQL and therefore take just a few milliseconds to retrieve. Isn't opening a file, reading the content, converting the string into an actual php array much slower. I understand data caching makes sense for heavy queries or when using memcache, but caching every query to file doesn't seem right. The site is pretty big and has lots of traffic, but I still think MySQL is better optimized than the file system, no? Please let me know when you are using data caching and why. Thanks a lot. Phil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
