=) I appreciate all the help i am goign to try to endeavor down the road and
see how good i do
Since i am not particularly fond of JavaScript =), lol java yes, js no =)
but i appreciate your help and everyone elses
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: Dick Applebaum [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 05, 2001 12:00 PM
To: CF-Talk
Subject: Re: LARGE QUERY RETURNS
Bill
If you absolutely must return that many rows to the browser at one
time (you can't page it)...
Then one way to limit both the CF processing and bandwidth is to
offload the formatting of the data to the browser as follows, (kind
of a pseudo WDDX):
1) in CF loop through the query and append each data column to a
string separated by some unique separator, e.g. the pipe | character
and each row by some other unique character, e.g. tilde ~
2) you return this string to the browser, along with a short
JavaScript routine... possibly in a hidden frame
3) when the page/frame is loaded by the browser it kicks off an
onLoad JavaScript routine which does a split of the string into an
array (rows of the original query).
4) Then you loop over this array doing another split of each row into
a subarray (columns of the original query).
5) You loop over this subarray and format the output as desired
You can do the same thing with WDDX but the WDDX packet is very large
due to the veberose format of XML,
Since all the data is fixed-field format, you don't need this overhead.
It is actually easier to write than to describe.
HTH
Dick
At 10:52 AM -0500 1/5/01, William J Wheatley wrote:
>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
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
