how many data size to fill in DataSet RRS feed

  • Question

  • I have to implement to test performance on database.

    I have 5 million record  have to select to dataset but it dosn't work

    then i want to know what solution i should do.


    Does i shoul change to use DataReader instead to DataSet

    (it forword only record and i don't want to modify any data)



    Sunday, November 19, 2006 8:33 AM

All replies

  • Hi kung

    yeah a 5 million row dataset resident in memory is going to be a little unwieldly

    You'll have to expand on what sort of performance you want to test

    are you just testing how quick it can return 5 million rows?

    You can use a data reader as it won't be trying to hold all 5 million rows in memory at once and
    write them out, but if your just testing the database you might as well use query analyser to run your query.

    Is it a likely requirement that queries will be pulling out 5 million rows?

    Your performance analysis should be as close to real usage of the system as possible as a read only denormalised database for reporting will perform well returning results but will suffer in a consistent update scenario.



    Friday, December 1, 2006 8:30 PM
  • Agree with Ed

    Sunday, December 3, 2006 3:44 AM