Re: dataset Performence Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Nigel,

Try measuring the time of "removing" rows from a huge dataset (i.e. lots of
datarows).

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
----------------------------------------------------------------------------

"Nigel Norris" <nospam@xxxxxxxxxx> wrote in message
news:%23Q5UytQmFHA.3256@xxxxxxxxxxxxxxxxxxxxxxx
> Just to get some facts instead of opinions, I ran some tests. The test
> populated a DataTable with varying numbers of records up to 1 million.
>
> The table was simple - 5 string columns, with one of those columns as the
> primary key. Around about 100 bytes of data per row. The kind of
> application I was thinking of was an address lookup table.
>
> The two numbers I was interested in were:
> - the load time per row
> - the time to retrieve a row by primary key
>
> Here's a few sample numbers (times in milliseconds):
>
> Count Load Retrieve
> 1,000 0.02 0.009
> 10,000 0.03 0.013
> 100,000 0.04 0.018
> 1,000,000 0.06 0.028
>
> CPU is an Athlon 2200. Framework version is V1.1
>
> Basically the load cost per row does rise, but not too bad. However this
> is a very simple table. I will interested to try this with the V2.0
> improvements.
>
> Retrieval time also rises, though quite slowly. Still, 30 microseconds
> per lookup is probably better than you'll get out of a database.
>
> So a reasonably large DataSet can work. However I would always be sure to
> measure the behaviour with the largest amount of data that I wanted to be
> able to handle before committing to it.
>
> --------
> Nigel Norris
>
>
>
>
>
>


.

Relevant Pages

  • Re: dataset Performence Issue
    ... I was thinking of was an address lookup table. ... Count Load Retrieve ... Basically the load cost per row does rise, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Delphi 8 and ado.net
    ... do with a ClientDataSet. ... The following can retrieve all 24 of my lookup tables and puts them ... Now to retrieve one of the lookup tables to populate a drop down list ... would be better to illustrate code for both techniques as I feel this ...
    (borland.public.delphi.non-technical)
  • Re: Finding last cell to contain same value as current cell?
    ... OK, looking through other messages, I found a lookup formula that works... ... Below, I have a fragment from the spreadsheet, with the ticket number & farm ... cell of the lookup range is set to be the FIRST load from that SAME FARM. ... Using following formula to find arrival time of last load same driver ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Writing to file
    ... > but I can not retrieve the data into $newline with join. ... I load a file into ... and then play around with the array a bit, then I would like to load it back ...
    (perl.beginners)
  • Re: Load New Record
    ... retrieve existing workorders on the system. ... modify my query for the dataset to retrieve last entered record and go ... Appears the load method is overloaded. ...
    (microsoft.public.dotnet.languages.csharp)