>- see footer for list info -< You are being charged for traffic between the database and web server? If so then then they are ripping you off as you should not be charged for that and I have never heard of any host charging for traffic between hosted servers.
Have u seen this. http://memcached.riaforge.org/ Russ -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Terry Riley Sent: 08 October 2009 09:18 To: [email protected] Subject: RE: [CF-Dev] memcached >- 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 -<
