i've a web page that loads the entire cust record tbl to simulate a auto
fill during data entry
this works great when tot cust recs < 1500, going over the 1500 numbers the
conescute page loads take several seconds.
that is the user must wait few seconds before the next page appears and then
they can continue their order entry
i am looking for a way to imporve this at for least 10000 records
thank you.
John Timney \(ASP.NET MVP\) - 05 Apr 2005 00:11 GMT
Your problem is more likely related to rendering the tables or html that are
being created in the output and the browser having to render them than the
actual binding events. Web pages are not the best medium for mass data
display, its worth having a look at some of the design guidelines for web
page design if you have not considered this already.
Make your select queries return smaller pockets of data for paging, take
advantage of fragment and page caching and you'll probably see a noted
difference.

Signature
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
> i've a web page that loads the entire cust record tbl to simulate a auto
> fill during data entry
[quoted text clipped - 7 lines]
>
> thank you.
ynewbie - 06 Feb 2006 14:43 GMT
Hi rasta,
I am lookig to do just that (autofill) i do have a very limited number
of rows from which to select (around 100). Could you guide me on how to
simulate the autofill function?
Thanks,