RE: Help required on CF Performance....

2002-02-07 Thread Nick Betts

Thanks Deanna!
Nick

-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: 07 February 2002 15:47
To: CF-Talk
Subject: Re: Help required on CF Performance


The answer was www.opensta.org. You can set up a script to run with 
multiple
virtual users and see how performance degrades (or doesn't) with 
additional
users.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]



__
Get Your Own Dedicated Windows 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=coldfusionb
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



Re: Help required on CF Performance....

2002-02-07 Thread Deanna Schneider

The answer was www.opensta.org. You can set up a script to run with multiple
virtual users and see how performance degrades (or doesn't) with additional
users.

-d



Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]


__
Get Your Own Dedicated Windows 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=coldfusionb
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



RE: Help required on CF Performance....

2002-02-07 Thread John McCosker

I'm not sure but I think this should be in the archives,
If I rember someone asked for the same sort of Stats not so long ago.

I didn't keep track of the thread I must admit.

Sorry not much help I know,

J

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 07, 2002 10:27 AM
To: CF-Talk
Subject: Help required on CF Performance


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 




   
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   





At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)
>
>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
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>> 
>>   
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>   
>> 
>>
>> 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



Help required on CF Performance....

2002-02-07 Thread Nick Betts

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 




   
  INSERT INTO Table
  (Field)
  VALUES ('#theQuery.FieldValue#')
   





At 05:15 PM 2/6/02 -0800, you wrote:
>dang tried the semi-colon already with no luck...thought that's what it
 wasgr ;-)
>
>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
>> beforejust saw it posted the other week too...geesh talk about
>> timing ;-)
>>
>> 
>>   
>> INSERT INTO Table
>> (
>> Field
>> )
>>VALUES
>> (
>> '#FieldValue#'
>> )
>>   
>> 
>>
>> 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
>>
>>
>>
>> 
>


__
Get Your Own Dedicated Windows 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=coldfusionb
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