perf issue for auto-fill with large number of records

[rasta]

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\)]

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.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

"rasta" <rs******@hotmail.com> wrote in message
news:eP**************@TK2MSFTNGP14.phx.gbl...

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.