>- see footer for list info -< No in the same way that we're suggesting here, but I've used it for abitrary datastores here and there. Easy to setup and administer, and I've found it plenty fast.
Rich On Thu, Oct 8, 2009 at 3:21 PM, Terry Riley <[email protected]> wrote: > >- 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 -< > _______________________________________________ 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 -<
