Re: Problems/Doubts: Implementing Disc. DB concept(Dataset)!!!

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

From: Patrice (nobody_at_nowhere.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 09:37:55 +0200

You may want to explain your scenario in more details.

In a disconnected scenario and with such an amount of data I would use
rather a "true" DBMS such as MSDE. I't's not clear if the disconnected model
essential in your scenario or if this is just to implement some kind of
"caching" (for example if you keep this for a long period what if the
computer hangs, are all updates lost ?)

Patrice

"saurabh" <anonymous@discussions.microsoft.com> a écrit dans le message de
news:428584B3-E7A8-45D1-B9EC-8EAEB948EF7D@microsoft.com...
>
> Hi All,
>
> I need to know :-
>
> 1. If there is an upper limit to Amount of data and the no. of Tables in a
Dataset which I have to cache at the Client system. (The requirements are
such that we need to cache some 120+ tables at client system, in order to
avoid round trips to Database as the no. of updations going to the Database
are huge. Datasets emerge as clear answer for our requirements of having a
local(client) data base, owing to the rich functionalities it provides.)
[Note: The Application is a Desktop Application application (WinForms)].
> 2. I also want to know whether there are any implicationts to the usage of
DatsSets in this manner.
> 3. If the amount of tables and data being cached in Datasets is not an
issue then What all Precautions do we need to take in order to avoid any
problems for example Memory leaks etc.
> You can also pass on some good resources/links on Pros and cons, and
precautions, BEST PRACTICES to be followed while implementing such a
disconnected database approach using DataSets.
>
> Thanks in advance,
> Saurabh
>

Relevant Pages

  • Re: Audacity and Gentoo
    ... >> Oracle Black Helicopter Base in Antarctica: ... they're not both going to be wrong by the same amount as ... There's over 5,000 games in that 15 ... TBH I doubt I'll ever migrate this system from a database to direct ...
    (uk.comp.os.linux)
  • Re: My Enterprise Architecture - your thoughts?
    ... > the technology is less important than the architecture - sufficient to ... This is not reasonable for reports. ... > As you can see there is a fair amount of mapping/transforming. ... Your relational database is going to be the single most ...
    (comp.object)
  • Re: General database safety question
    ... preventive measures to take for the database of our product. ... Scenario 1: Laptop on which Sql Server is installed in stolen. ... Trusted Connection to connect to database and compromise data. ...
    (microsoft.public.sqlserver.server)
  • General database safety question
    ... preventive measures to take for the database of our product. ... Scenario 1: Laptop on which Sql Server is installed in stolen. ... Trusted Connection to connect to database and compromise data. ...
    (microsoft.public.sqlserver.server)
  • Re: Summing based on various critiera
    ... I know full well what a flat file is and I know what a database ... database arrangement. ... it has been the same amount of monies for everyone. ... one amount for adults and one amount for kids. ...
    (microsoft.public.excel.worksheet.functions)