> 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
Yeh, I think then you best bet is to break it up into large chunks with next
and previous. Or maybe you can wait till CF5, since you can process parts
of a page before the whole page has been processed by the server. Then you
might be able to spit out chunks of say a couple hundred records while the
next couple hundred are being produced.
--Greg
----- Original Message -----
From: "William J Wheatley" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 05, 2001 11:16 AM
Subject: RE: LARGE QUERY RETURNS
> 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
