Yes, I will research Ajax. You mentioned the learning curve. Does this mean learning Javascript? I know basic javascript but have not done anything too heavy-duty.
Yes, I do the search using LIKE in my sproc. I did think of that if someone keys in like the letter "A". I will put in some safe guards for this. -------------- Original message -------------- From: "Falls, Travis D (HTSC, CASD)" <[EMAIL PROTECTED]> AJAX would allow you to update your data without a refresh of the browser. That is its benefit; by not having to bring down the entire page, you simply repopulate that data that is changing... the down side is AJAX has a learning curve and blurs the separation of presentation logic in my opinion. On a side note be careful with queries like that I am assuming you are doing a search using %somevalue%. I had an app doing this and a user actually searched for %a% which really put a hurting on the server. ;-) what I did to get around this was to make sure they searched for at least 2 letters. Travis D. Falls | Consultant RAFT.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: AspNetAnyQuestionIsOk@yahoogroups.com [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, December 21, 2005 1:37 PM To: AspNetAnyQuestionIsOk@yahoogroups.com Subject: Re: [AspNetAnyQuestionIsOk] Large datasets bound to a repeater I have another question related to my problem. I have a textbox associated with each column in my repeater. The user can key in a word like "food" in the description textbox and then I post back and select all rows that have the word "food" in it. From my testing, this usually runs quickly. My question is about Ajax. Would Ajax be useful at this point? To be honest, I have only recently heard about Ajax and I am having problems determining when to use it. I have downloaded the Ajax.Net and added it as a reference to my project. Thanks, Bob -------------- 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 ************************************************************************* This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential and/or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies. ************************************************************************* 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 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/
