Ways to speed up results loading to a form

[programmher]

Is there any way to speed up returning results to my form? I execute an SQL in query analyzer and it takes 1 second to execute and return my result. I execute the same query from my CF form and it actually takes less time to execute but several seconds to load the results to my form.

Is there some way to speed this up?

 

[SidianConsulting]

It sounds like the form is pretty big, and the bottleneck in that case would be the web browser rendering the page. Nested tables usually cause this, so maybe check your HTML.

-Tek