>- see footer for list info -< Thanks for the suggestion, Rich. It wasn't one I had even thought of - have you had occasion to use it?
Cheers Terry (free event listings at http://www.confexdb.co.uk) ----- Original Message ----- > *From:* Rich Wild <[email protected]> > *To:* [email protected], Coldfusion Development > <[email protected]> > *Date:* Thu, 8 Oct 2009 09:34:00 +0100 > > 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 -< > > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.421 / Virus Database: 270.14.7/2421 - Release Date: > 10/07/09 20:49:00 > > > -- > *Included Files:* > am2file:001-HTML_Message.html _______________________________________________ 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 -<
