In this instance, changing from one version of SQL Server to another is not going to get you a noticable performance boost. This is a display and rendering problem, not a retrieval problem.
On 12/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I agree. I pretty much already knew the answer but figured I would give you > guys a shot. Usually I would do something like a treeview structure with > product category 1. The user would click on a category 1 and then select > Category 2. When category 2 is clicked I would fetch and display the 300 or > so products. But management is being kind of hardheaded on this one. I have > already given them sorting and searching capabilities to easily find > products. And like I said, presently I display 20 rows at a time and allow > them to click the Next button to fetch the next 20 rows. It is all very > fast. I will just have to let them know that this impossible. I am going to > try running my database using SQL 2005 though. I assume it is faster but I > don't think this is the solution. > > -------------- Original message -------------- > From: Dean Fiala <[EMAIL PROTECTED]> > 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 > > > SPONSORED LINKS Basic programming language Computer programming languages > Programming languages > Java programming language > > > > YAHOO! GROUPS LINKS > > Visit your group "AspNetAnyQuestionIsOk" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > [Non-text portions of this message have been removed] > > > > > > 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/
