Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / ASP.NET / Caching / February 2006

Tip: Looking for answers? Try searching our database.

perf issue for auto-fill with large number of records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
rasta - 04 Apr 2005 20:19 GMT
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,



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.