The best way to do this is with a load test tool. Create a script that walks through your site and then run the test with different settings for the number of concurrent users. Compare the results to determine the best setting for that application. That is also a good time to enable debugging and get a good idea of where your bottlenecks might be - go through the site manually while it is under load and examine the execution times. Microsoft has a free tool that you can use for putting the load against the site - http://webtool.rte.microsoft.com/. Ballpark figures seem to be between 5-10 per processor depending on who you speak with. If you have more questions feel free to contact me offline.
-----Original Message----- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:17 AM To: CF-Talk Subject: COncurrent Users Hi, Is there a way to test system performance based on differenet number of concurrent users? Are there any guidelines from macroMedia on the maximum number of concurrent users CF server supports? I realise this is quite ballpacrk but basically need to presnet some figures to our client. Regards, Nick -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 08:02 To: CF-Talk Subject: Re: looping inside cfquery - brain on vacation Maybe this? Loop around the <cfquery> <cfloop query="theQuery"> <cfquery name="blah" datasource="blah"> INSERT INTO Table (Field) VALUES ('#theQuery.FieldValue#') </cfquery> </cfloop> At 05:15 PM 2/6/02 -0800, you wrote: >dang tried the semi-colon already with no luck...thought that's what it was....grrrrrrrrr ;-) > >Thanks > >Bryan Stevenson >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >p. 250.920.8830 >e. [EMAIL PROTECTED] >--------------------------------------------------------- >Macromedia Associate Partner >www.macromedia.com >--------------------------------------------------------- >Vancouver Island ColdFusion Users Group >Founder & Director >www.cfug-vancouverisland.com > >----- Original Message ----- >From: "Steve Oliver" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, February 06, 2002 5:06 PM >Subject: RE: looping inside cfquery - brain on vacation > > >> Oh nevermind, your not looping over the columns of the query (long day >> as well) >> >> I think you need a semi-colon at the end of your query, since that will >> put multiple inserts in one cfquery. >> >> ______________________ >> steve oliver >> atnet solutions, inc. >> http://www.atnetsolutions.com >> >> >> -----Original Message----- >> From: Steve Oliver [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, February 06, 2002 8:02 PM >> To: CF-Talk >> Subject: RE: looping inside cfquery - brain on vacation >> >> >> Hmmm, well if one of your fields is numeric, then that wouldn't work, >> since numeric values don't need 's around them, you could use the >> isNumeric() function for that. >> >> ______________________ >> steve oliver >> atnet solutions, inc. >> http://www.atnetsolutions.com >> >> >> -----Original Message----- >> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, February 06, 2002 8:01 PM >> To: CF-Talk >> Subject: looping inside cfquery - brain on vacation >> >> >> OK..long day..CF whining about syntax...help! >> >> The situation: >> >> CF doesn't like my syntax for this bit of looping over a query to insert >> muliple records. It's >> complaining about the final ")" closing bracket for the insert. Any >> ideas? I'm sure I've done it >> before....just saw it posted the other week too...geesh talk about >> timing ;-) >> >> <cfquery name="blah" datasource="blah"> >> <cfloop query="theQuery"> >> INSERT INTO Table >> ( >> Field >> ) >> VALUES >> ( >> '#FieldValue#' >> ) >> <cfloop> >> </cfquery> >> >> TIA >> >> Bryan Stevenson >> VP & Director of E-Commerce Development >> Electric Edge Systems Group Inc. >> p. 250.920.8830 >> e. [EMAIL PROTECTED] >> --------------------------------------------------------- >> Macromedia Associate Partner >> www.macromedia.com >> --------------------------------------------------------- >> Vancouver Island ColdFusion Users Group >> Founder & Director >> www.cfug-vancouverisland.com >> >> >> >> > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
