NEWBIE: How much "disconnected data" it too much?

Posted on 2006-04-27
Last Modified: 2010-04-16
Dear Experts,

I'm a C# newbie (via Java) looking at ADO.NET for the first time.

I'm trying to understand when you would use "disconnected data", using DataSets and DataAdapters.  My understanding so far is that although the "disconnected data" behaves as though it were a little mini-database, it's all actually being stored IN MEMORY.  Is that right?

If so, it seems there must be some vague upper limit.  For instance, my Java application might currently retrieve 100,000 customer records, each of say 500 bytes (=50Meg), using a traditional "connected" ResultSet.  Is it practical to hold all that in a "disconnected" DataSet?

Question by:BrianMc1958
    LVL 6

    Accepted Solution

    It is true that datasets hold the data in memory.

    Although I don't know the upper-limit, I would definitely say that 100,000 records is a bit too much to hold in memory. It's wise to select only the data that you need. It's better to connect a few times to do your database processing then it is to connect once and get a huge lump of data, I believe. Someone will probably know more about this then I do, but that's my opinion.
    LVL 8

    Assisted Solution

    it really depends on how much your machine and application can cope with, aswell as what the data is used for

    for a windows app on a machine with a gig of ram, 50meg is nothing really
    for a web app on a server with 32 gig of ram, 50meg per session will be fine for a small number of users but once you get a few hundred it'll die

    if you're constantly using the data, and it's pretty static, it may be best to keep it in memory instead of repeatedly retrieving it from a database/file.

    Author Comment

    Thanks again!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Live - One-on-One C# Help from Top Experts

    Solve your toughest problems, fast.
    C# experts are online now and ready to help you.

    Suggested Solutions

    Article by: Ivo
    C# And Nullable Types Since 2.0 C# has Nullable(T) Generic Structure. The idea behind is to allow value type objects to have null values just like reference types have. This concerns scenarios where not all data sources have values (like a databa…
    This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now