473,320 Members | 2,088 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

esitmate for dataset weight

hey all,

how many records is considered a lot to hold in a dataset?

thanks,
rodchar
Nov 19 '05 #1
5 922
How many did you have in mind?

You are shoving it all into memory
on top of the overhead of the various
collections in a DataSet.

Does it really need to be in a DataSet or
can it be in a DataTable or some other
more efficient storage mechanism?

--
Robbe Morris - 2004/2005 Microsoft MVP C#
EggHeadCafe's RSS Search Engine
http://www.eggheadcafe.com/articles/...h/default.aspx


"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:0E**********************************@microsof t.com...
hey all,

how many records is considered a lot to hold in a dataset?

thanks,
rodchar

Nov 19 '05 #2
it depends on the row size, and use.

a 1000 rows of a 1 int column table is probably lighter than 10 rows of a
table that has about 2k text per row. also if its only used on the server it
can be bigger than if passed between tiers with soap.

-- bruce (sqlwork.com)

"rodchar" <ro*****@discussions.microsoft.com> wrote in message
news:0E**********************************@microsof t.com...
hey all,

how many records is considered a lot to hold in a dataset?

thanks,
rodchar

Nov 19 '05 #3
"=?Utf-8?B?cm9kY2hhcg==?=" <ro*****@discussions.microsoft.com> wrote in
news:0E**********************************@microsof t.com:
hey all,

how many records is considered a lot to hold in a dataset?

The less the better : )

Just consider a dataset an in memory cache. To see how much space your data
set will take up, multiply your row size by the number of rows you're
planning on having, and add some fudge factor to account for the dataset
overhead.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.

Newmarket Volvo Sucks! http://newmarketvolvo.tripod.com
Nov 19 '05 #4
"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> wrote in
news:e2**************@TK2MSFTNGP15.phx.gbl:
Does it really need to be in a DataSet or
can it be in a DataTable or some other
more efficient storage mechanism?


Is a datatable that much more efficent than a dataset? I would have thought
they're roughly the same. (i.e. 1 table dataset, 1 table datatable).

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.

Newmarket Volvo Sucks! http://newmarketvolvo.tripod.com
Nov 19 '05 #5
There is less overhead. If you are working with a large
set of data, there is going to be at least some gain.

--
Robbe Morris - 2004/2005 Microsoft MVP C#
EggHeadCafe's RSS Search Engine
http://www.eggheadcafe.com/articles/...h/default.aspx


"Lucas Tam" <RE********@rogers.com> wrote in message
news:Xn**************************@127.0.0.1...
"Robbe Morris [C# MVP]" <in**@eggheadcafe.com> wrote in
news:e2**************@TK2MSFTNGP15.phx.gbl:
Does it really need to be in a DataSet or
can it be in a DataTable or some other
more efficient storage mechanism?


Is a datatable that much more efficent than a dataset? I would have
thought
they're roughly the same. (i.e. 1 table dataset, 1 table datatable).

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.

Newmarket Volvo Sucks! http://newmarketvolvo.tripod.com

Nov 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: geilen | last post by:
I'm trying to use a dataset returned from a web service in an unmanaged C++ (MFC) client. The dataset is returned as a BSTR, and I'm having trouble reading the BSTR into an XML document for...
1
by: Rob via .NET 247 | last post by:
Ok, I'm new to .NET so I'm afraid I'm doing something stupidhere, but I'm trying to populate a DataSet manually from aDataReader, and its turning out to be ridiculously difficult. Yes, I could use...
2
by: ALPO | last post by:
ANy good examples of paging against a cached dataset. Our datasets will be cached in viewstate.
3
by: Ben Becker | last post by:
I am trying to build a custom crosstab type of grid where I take some items in a data grid and based on the content of the current item compared to the previous item, determine if a new row in a...
1
by: arnold | last post by:
Hi, I've been knocking my head against the wall trying to create an XSL transform to perform "normalizations" of a set of XML files that have a common structure. % XML file before transform
8
by: BeGreen | last post by:
Hi All, I am trying to read the xml file below using java/xml API, such as DocumentBuilderFactory, DocumentBuilder and so on. Do you know if there is any java/xml class, I can use to be able...
3
by: goldreads | last post by:
Hey guys, I've been putting together a line graph in Image_Graph. And I can't seem to find an answer to change the layout of few things. Here is my graph: http://www.goldreads.com/test.png ...
8
by: Ruben | last post by:
error: passing `const Weight' as `this' argument of `float Weight::wgt()' discards qualifiers seems to be some sort of standard error format that I'm not understanding. I have code that...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.