Yeah, but I'm going to need a little time to get things together for you. We're just now finishing two big projects at the same time, so it may take a few days. Also, some of the things you're asking for regarding load testing are not done that way: there is no such thing as a "common configuration." And regarding physical environment, that really depends on things entirely outside of Plum.
Finally, regarding migrating CFQUERY calls to stored procedures, there is so much misinformation about this that I've already broken fifteen sticks by shaking sticks at it. You can actually do *tremendous* damage to performance by moving all your CFQUERY calls to stored procedures due to the way selectivity metrics stick to query plans and how those query plans are used to choose indexes (or not). You won't hear about this on CF-Talk or just about anywhere else in the ColdFusion arena because people just keep repeating the same misinformation they hear from others, so if you repeat what I've said to just about anyone in the community they'll say I'm full of it, but I can prove it to you by teaching you how database servers work under the covers. It's complicated (one reason why it's not talked about), but it will make sense once I teach it to you. I'll try to respond to the remaining items as soon as I can. Respectfully, Adam Phillip Churvis Member of Team Macromedia http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "Aaron Longnion - hotmail" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, March 27, 2005 11:35 PM Subject: Re: [plum] Plum under load? Any thoughts? thanks, Aaron ----- Original Message ----- From: Aaron Longnion - hotmail To: [email protected] Sent: Friday, March 25, 2005 6:47 PM Subject: [plum] Plum under load? Hi Adam and David - I'm very interested in any information you can provide about the performance implications of using the Plum framework under very heavy load. At my new job, I may want to start convincing folks to use Plum in certain instances, especially new development. I know they're going to want to know how it performs under intense load (perhaps eBay-type load within a few years, if everything goes well). We'll really want to scale our applications (application, web, and database clustering will most likely be involved). We would use some pretty powerful app and DB servers, with a mix of Win 2K and Win 2003. The DB will be SQL Server 2000. So... 1.) What kind of load testing have you done, with what tools, with what hardware/software specs, and what were the results? 2.) How do you suggest setting up Plum in a CF MX 6.1 clustered environment (possibly multiple machines, and probably multiple instances of CF)? 3.) Normally, with a small cluster (2 or 3 app servers), we would use Client variables with DB storage. So, would you do this in a larger cluster under very high load? Perhaps we could use a seperate DB machine just for Client session management? 4.) Are there performance implications with the way Plum puts so many CFC's in the Application scope? 5.) I assume you would recommend switching as many of the <CFQUERY> tags to Stored procedure calls? By the way, one recommendation would be for an easier way to just make Plum use all sprocs instead of inline <CFQUERY> code in the V1.1, as if you guys don't have enough to do... :) 6.) Posting/documenting the results of performance metrics for Plum under common configs with intense load would be very helpful if anyone has the time and setup to do it. 7.) We might also move to CFMX 7 soon, so any information on how Plum performs under load with 7 would be helpful. Thanks much! Aaron ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
