There are things you could try, like loading only a minimum-data row that has a few key pieces of info about the product and then when the user selects the row either expanding it to show all product data via AJAX or opening it on a detail page.
But the basic problem is that: No one actually needs or wants to look at 25,000 individual rows. That's not a user interface that's a useless interface. They want to find what they're looking for, not have to hunt for it, or even wait for it to load. It's a whopping huge amount of html. At a conservative 100 bytes/row it's 2.5 MB web page! So for a poor slob on a dial-up connection is going to be able to get a cup of coffee while it loads. Even a high speed connection is going to run into time-out issues and cranky browsers. On 12/21/05, bh0526 <[EMAIL PROTECTED]> wrote: > Hi all, > > I am rewriting an old VB 6 app to ASP.net / VB.Net. The application > is for some commercial software we sell. I am having some problems > since I have to work with enormous amounts of data. For example, > the Products table is 360,000 rows. > > I am presently working on a page that allows the user to select one > or more products and then run some statistical reports against these > selected products. I am using the repeater control to display the > products since this loads much faster than the datagrid. I also > fetch all products that start with the letter "A" when the page > loads. Above my repeater, I have linkbuttons like A B C D thru Z. > The user clicks one of these letters and the products starting with > this letter are displayed. This is fine but some letters like "C" > have about 25,000 products. I usually get a timeout error before > the repeater is filled. Or it just takes way too long. So I made > my repeater only display 20 rows at a time and then have Next / Prev > buttons to get rows as I need them. Now everything is very fast. > The problem is that management does not like this. They are ok with > the letter links but if the user clicks on "C" then they want all > the "C" products displayed so that the user can scroll quickly to > the bottom. I also have textboxes for searching and my headings are > links that when clicked will sort by that field. My problem is > loading 25,000 rows of data on a web page. Is there anything at all > I can do to make this work? > > Thanks, > Bob > > > > > > > > Yahoo! Groups Links > > > > > > > > -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
