Re: dataset Performence Issue

Tech-Archive recommends: Speed Up your PC by fixing your registry

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
    ... > - the time to retrieve a row by primary key ... > Count Load Retrieve ... > Basically the load cost per row does rise, ... > per lookup is probably better than you'll get out of a database. ...
    (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)