Why don't you try it!!!!
Quoting Peter Brunone <[EMAIL PROTECTED]>:
> How is that going to make 2.5MB of data come down the wire faster?
>
> On 12/21/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >
> >
> >
> > Use an ASPCompat page with Old ADO Connection and Recordset
> > Use the GetRows() function to pop the data into an Array
> >
> > <%@ Page Language="vb" AutoEventWireup="false" ASPCompat="true"
> > Codebehind="RepeatThis.aspx.vb" Inherits="COURTS.RepeatThis"%>
> >
> > This CODE WORKS. I JUST TESTED IT!!!!!!
> > Modify it for YOUR Application
> >
> > Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
> > System.EventArgs) Handles MyBase.Load
> > 'Put user code to initialize the page here
> >
> > Dim dbConn As Object
> > Dim rs As Object
> > Dim arrRows As Object
> > Dim intX As Integer
> > Dim intY As Integer
> >
> > ' remember to USE an ADO connection string;for ease of use, I
> > created
> > an ODBC DSN
> > ' from the ODBC Admin Interface
> > dbConn = Server.CreateObject("ADODB.Connection")
> > dbConn.Open("DSN=MyDSN;Uid=MyUser;Pwd=MyUser")
> > rs = dbConn.Execute("SELECT Item, Price, Qty FROM Items")
> > arrRows = rs.GetRows()
> > rs.Close()
> > dbConn.Close()
> >
> > ' creat the datasource table for the repeater
> > Dim _table = New DataTable
> >
> > ' add the columns needed to the table; repeat as necessary
> > Dim _col1 As New DataColumn
> > Dim _col2 As New DataColumn
> > Dim _col3 As New DataColumn
> >
> > _col1.ColumnName = "Item"
> > _col1.DataType = System.Type.GetType("System.String")
> >
> > _col2.ColumnName = "Price"
> > _col2.DataType = System.Type.GetType("System.String")
> >
> > _col3.ColumnName = "Qty"
> > _col3.DataType = System.Type.GetType("System.String")
> >
> > ' add the columns to the table
> > _table.Columns.Add(_col1)
> > _table.Columns.Add(_col2)
> > _table.Columns.Add(_col3)
> >
> > ' create a datarow
> > intY = UBound(arrRows, 2)
> > For intX = 0 To intY
> > Dim _row As DataRow
> > _row = _table.NewRow()
> > _row("Item") = CType(arrRows(0, intX), String)
> > _row("Price") = CType(arrRows(1, intX), String)
> > _row("Qty") = CType(arrRows(2, intX), String)
> > _table.Rows.Add(_row)
> > Next
> > Repeater1.DataSource = _table
> > Page.DataBind()
> >
> > End Sub
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Quoting Dean Fiala <[EMAIL PROTECTED]>:
> >
> > > 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
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income homes are not online. Make a difference this holiday season!
http://us.click.yahoo.com/5UeCyC/BWHMAA/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/
