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 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/
