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)
thanks
how many data size to fill in DataSet
Avi Gershon
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.
Regards
Ed
thechristopher
Agree with Ed