What is faster: DataReader or DataSet or something else?

Hot Topic

SSIS Excel Source: Index is not valid
multiple result sets from stored proc
HTTP status 400: Bad Request
System.Web.Services.Protocols.SoapException: The item '/foldername' cannot be found
Does anyone know how to fix this?
Loop through each record and then each field within each record
Concatenate field based on unique id. (Follow up)
Data Conversion Components & Code Page issue
Re-Create All Indexes in database
sql server backup (difference between override and append)

SQL Server

Bug in SQL 2005 SP1
copying table in a database
Upgrading MS SQL Server 7 SP4 Standard to 2005 Enterprise (Eval Edition)
SQL ALTER COLUMN causes a Possible schema corruption.
server is not a subscriber (SQL2005)
CTE in a DSV named query
I need to compare two string values and give confidence score on how much they are similar.How do we use Fuzzy look up to do it?
Virtual Memory best practices with SQL 2005?
Transaction Log does not truncate and shrink using a SQL Server 2005 Maintenance Plan
Problems with SQL express

What is faster: DataReader or DataSet or something else?

Hi,

I need to read 250,000 records and show this information.
I am using DataReader and it takes 8 seconds. I need to raise it to 0.8 seconds atleast.
What is faster: DataReader or DataSet or something else

Thank's
Alexei


Answer this question

What is faster: DataReader or DataSet or something else?

  • Debra

    Hi,

    I am using the sql server on local machine.

    Thank's
    Alexei

  • HongQ00

    Increase your network's bandwidth then.  You can't just expect all of those bytes to magically cross the wire in 0.8 seconds.  No .NET class is going to help you gain that kind of speed improvement.
     

    --
    Adam Machanic
    Pro SQL Server 2005, available now
    http://www..apress.com/book/bookDisplay.html bID=457
    --
     
     
    Hi,

    I need the all data. I am using it for drawing objects on the screen.

    thank's
    Alexei

  • Mog0

    Hi,

    I have tryed indexes, stored procedure and other known ways... But it doesn't help me much and sometimes i have the worth time.

    Thank's
    Alexei

  • Elliott_Ward

    Is it an I/O issue   Have you tried looking at some performance counters to see where the bottleneck might be
     
    Is it a query issue   How complex is the query   Do you have proper indexes in place
     

    --
    Adam Machanic
    Pro SQL Server 2005, available now
    http://www..apress.com/book/bookDisplay.html bID=457
    --
     
     
    Hi,

    I am using the sql server on local machine.

    Thank's
    Alexei

  • Graham Seppings

    DataReader is much faster than DataSet. Actually DataSet is populated using DataReader object.

    I guess in your case the bottleneck is in the amount of data you transfer to client application. Try to reduce the row size you send to the client (don't select columns unless they are required). Another way is to show only portions of data as the user typically doesn't need to have the whole data list available.

  • KeithS-MS

    Can you post the table structure and query you are running

    If you really need all the data than I cannot see how to speed up your task.
    One thing yo may do is to perform data load/processing in a separate thread, but it will just make an application responsive to user during data load.

  • hampk

    Are you low on memory

  • Dipsy Po

    Hi,

    I need the all data. I am using it for drawing objects on the screen.

    thank's
    Alexei

  • LKHall

    Hi,

    My computer has 512 MB of memory.
    My application must run on 256MB at clients computers.

    Thank's
    Alexei

  • What is faster: DataReader or DataSet or something else?
Answer this question