What is faster: DataReader or DataSet or something else?

Hot Topic

Using Extended SQLCmd Commands with T-SQL
Sql instance error after upgrading to Express Advanced
EXCEPT Operator
Using MS Access 2003 Project with SQL Server 2005
SQL Agent failing when running SSIS Package
Stored Procedure using linked server...HELP
Will IP Change cause problems?
Assembly MyAssembly was not found in the SQL catalog of database MyDB
Changing SQL-command with a script
A probably simple question

SQL Server

rrRenderingError
Select - 4 hours
Open table + NULLs
Is assembly code replaceable?
Management Studio all databases . . .
Best way to handle License issues
Error that has nothing to do with my cube
How to Execute a DiffGram
SQL reporting services 2005 with CLR
sp_OACreate and Microsoft's RICHTEXT.RichtextCtrl

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?

  • Dems

    Hi,

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

    Thank's
    Alexei

  • Andy.NET2005

    Hi,

    I am using the sql server on local machine.

    Thank's
    Alexei

  • hainm

    Are you low on memory

  • crimzonthunder

    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

  • Satish Chandran

    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.

  • hiling

    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

  • Andy Lichey

    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.

  • Vlad Dogaru

    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

  • chiln1208

    Hi,

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

    thank's
    Alexei

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