>- see footer for list info -< Could you use an Apache Derby database as an interstitial datastore, taking weight off your mySQL server?
Rich On Thu, Oct 8, 2009 at 9:18 AM, Terry Riley <[email protected]> wrote: > >- see footer for list info -< > Yes, Russ, I know! We had already done some CF query caching, but the > site is fairly data-sensitive and any caching is going to be short-lived. > ( view http://www.football.mitoo.co.uk and you'll see what I mean ) > > Using MySQLs cache at least ensured that the data was up-to-date, with > MySQL dropping any query from cache related to a changed data table. > > CFs query cache has no way to detect the changed data, and even if you > could tie a data change to a set of particular queries, there's no way > in CF to drop that related set of queries from cache (without running > them all again with a 0 timeout - which seems pointless. > > At least, if I understand it right, with memcached we could cache a > query (each one having an individual key) and if a related table is > changed with an SQL update/delete/insert in our code, we can designate > an immediate dropping of the named/related cached query. That way it is > ready to be recreated the next time it is called for. > > One of the main reasons I'd like to try memcached is one you mentioned - > using memory outside of that generally used for CF, and being able to > distribute the cache over 4 or 5 servers. > > I'd still like to find a source of good instructions for a CF client, > though. In order to cut down on traffic charges (like upwards of > 55GB/day) we have moved the MySQL server back onto the same box as the > CF app/servers - with added memory. > > Thanks for the help. > > Cheers > Terry > (free event listings at http://www.confexdb.co.uk) > > ----- Original Message ----- > > > *From:* "snake" <[email protected]> > > *To:* <[email protected]>, "'Coldfusion Development'" > > <[email protected]> > > *Date:* Wed, 7 Oct 2009 21:04:52 +0100 > > > > Not personally but I worked for a client that used it and they said > > it was > > great. I believe in their case they were using it to share memory > > between > > multiple cf servers. > > just caching your cfqueries would reduce the traffic to your mysql > > server, > > so perhaps some application tuning is required. > > > > Russ > > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of Terry Riley > > Sent: 07 October 2009 18:03 > > To: [email protected] > > Subject: [CF-Dev] memcached > > > > >- see footer for list info -< > > Has anyone here implemented memcached on their CF8 server(s)? Has it > > been worthwhile? What pushed you in that direction? > > > > I'm being pushed by client management to do something to alleviate > > the traffic with the MySQL server, by caching on the CF server > > instead of relying on MySQL's query cache. > > > > Only solution I can see is something like memcache, but I find the > > information on setup/usage of the Java/CF client (not the memcached > > server) very sparse indeed. Are there resources out there that I'm > > just not finding? > > > > I understand that CF9 has all sorts of improvements in caching, but > > we can't afford to go that route. > > > > Cheers > > Terry > > (free event listings at http://www.confexdb.co.uk) > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go > > to > > http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > help -< > > > > No virus found in this incoming message. > > Checked by AVG - www.avg.com > > Version: 8.5.420 / Virus Database: 270.14.5/2418 - Release Date: > > 10/06/09 18:34:00 > > > > _______________________________________________ > > For details on ALL mailing lists and for joining or leaving lists, go to > http://list.cfdeveloper.co.uk/mailman/listinfo > > -- > CFDeveloper Sponsors:- > >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
