Fetch large data

[rajsinha]

Hi,

I want to start displaying data on a web page for a query that will return
thousands of data. The problem is that the user does not want to wait till the
query returns the whole record set. Also, if the user has a lower memory on his
local machine, he runs out of memory. Can we start painting the page with the
data in batches?

[jdeline]

There are at least two resource consumers when ColdFusion parses and executes a
page. One is the time required to perform the queries, and the other is the
rendering of the page, that is, creating the HTML. Surprisingly, the rendering
can take much longer than the queries if you are dealing with a very large
record set.

I would suggest you turn on full ColdFusion debugging and see how long your
queries are running. Subtract this from the total page execution time and you
get your rendering time.

Knowing what these numbers are will help define what problem to tackle. If
the rendering is the issue, you may not want to waste time optimizing the
queries.

[rajsinha]

Thanks. I will find this out. I suppose I might be having a rendering issue,
because users did complain having problems on lower memory user machines.

But, thanks a lot. I will investigate further, and then come back.

Raj

[SQLMenace]

Lookup CFFLUSH