well the 3 Clustered CF servesr are all Dual PIII 800 with 1gig of ECC ram,
Dual SCSI cards with 4 10X RPM Cheetahs and the DB servers are DUAL PIII800
with 1.5 GIG of ECC ram dual DPT scsi cards with 4 10X RPM Cheetahs
so i dont think horsepower is the issue lol
Bill Wheatley
Director of Development
AEPS INC
Allaire ColdFusion Consulting Partner
Allaire Certified ColdFusion Developer
http://www.aeps.com
ICQ: 417645
http://www.aeps2000.com
954-472-6684 X303
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorized alterations to
this e-mail or attachment to it
-----Original Message-----
From: Greg Wolfinger [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 11:08 AM
To: CF-Talk
Subject: Re: LARGE QUERY RETURNS
> Now is there
> anything i can do to cut down on the time it takes to show those, other
then
> doing a Next Previous system??
Beef up your server with some more RAM and a second processor.
--Greg
----- Original Message -----
From: "William J Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 05, 2001 10:52 AM
Subject: LARGE QUERY RETURNS
> Ok I have found that when i return alot of returns to a page, 5000+ it
adds
> quite a bit of time to the processing on the CF side with displaying the
> information as opposed to it being database bottleneck.
>
> In Fact the database is Hustling returning the 70,000 records in about 4
> seconds but it takes CF quiet a bit of time to display them. Now is there
> anything i can do to cut down on the time it takes to show those, other
then
> doing a Next Previous system??
>
>
> Bill Wheatley
> Director of Development
> AEPS INC
> Allaire ColdFusion Consulting Partner
> Allaire Certified ColdFusion Developer
> http://www.aeps.com
> ICQ: 417645
> http://www.aeps2000.com
> 954-472-6684 X303
>
> IMPORTANT NOTICE:
> This e-mail and any attachment to it is intended only to be read or used
by
> the named addressee. It is confidential and may contain legally
privileged
> information. No confidentiality or privilege is waived or lost by any
> mistaken transmission to you. If you receive this e-mail in error, please
> immediately delete it from your system and notify the sender. You must
not
> disclose, copy or use any part of this e-mail if you are not the intended
> recipient. The RTA is not responsible for any unauthorized alterations to
> this e-mail or attachment to it
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
