You can also look into using an external cache (memcache, S3, or any of the more esoteric ones), that way you have way more extensibility than what CF can give you in a struct.
On Thu, Mar 12, 2009 at 3:10 PM, Adrian Moreno <[email protected]>wrote: > You might want to check out Rob Brooks-Bilson's presentation from MAX 2008: > "Advanced ColdFusion Caching Strategies" > > http://tv.adobe.com/#vi+f15383v1018 > > You can store a ton of keys in a struct, but you'll reach a point where the > whole app server will grind to a halt as the number of keys reaches a > certain point. Can you give us a clue as to what kind of "something" you > need to "do" as you match each URL? > > --- Adrian > > ------------------------------ > *From*: "David McGuigan" <[email protected]> > *Sent*: Thursday, March 12, 2009 4:53 PM > *To*: [email protected] > *Subject*: [CFCDEV] Cached struct key lookup approach vs. database to the > death > > > I'm struggling to find some real numbers or guidelines on this and am > hoping I can borrow from community experience instead of authoring my own > tests. > Theoretical: I have a huge web site with about 1 million different "pages" > (urls) and hundreds of thousands of page serves per day. > > Each page serve, I need to match the URL to a value and do something with > it. > > Assuming I have a highly-capable server ( ex: 128GB of RAM or more and two > quad core Xeons with standard 15k RPM drives ) and that both the database > and the application servers are running on the same box and sharing the same > hardware... > > how would the following two approaches compare at this scale > (theoretically, unless you have personal experience with this scale in which > case: CALL ME) in terms of performance and efficiency: > > 1. Caching a single struct with keys that match the URLs and values that > correspond to the values in the application scope and using this code: > > application.struct[ url ] > > and > > 2. Looking up the URL in a database table on each request > > ? > > Thanks a million. > > > > > > > > > -- Oscar Arevalo http://www.oscararevalo.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
