"Nick nkw" <nick.y.wang@hotmail.com> wrote in message
news:epUH1$cVHHA.3652@TK2MSFTNGP04.phx.gbl...
>I am creating a winforms application. Drag and drop and VS 2005
>automatically created Dataset based on the MDB schema. I found it seems
>that all the changes are cached in the memory. Will the default way has any
>scalability issue if the database tables are huge? What's the solution if
>it does have the issue?

"Nick nkw" <nick.y.wang@hotmail.com> wrote in message
news:epUH1$cVHHA.3652@TK2MSFTNGP04.phx.gbl...
>I am creating a winforms application. Drag and drop and VS 2005
>automatically created Dataset based on the MDB schema. I found it seems
>that all the changes are cached in the memory. Will the default way has any
>scalability issue if the database tables are huge? What's the solution if
>it does have the issue?

>Any operations that need to be taken against the entire table need to be
>done on the server--not in memory.

> One of the problems with the DataTable object is its name. While it can
> contain all of the rows a database table, it's (insert expletive) to do
> so. As I discuss at length in the book, a DataTable should contain a
> logical subset of the rows you need at the time. Any operations that need
> to be taken against the entire table need to be done on the server--not in
> memory.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "Nick nkw" <nick.y.wang@hotmail.com> wrote in message
> news:epUH1$cVHHA.3652@TK2MSFTNGP04.phx.gbl...
>>I am creating a winforms application. Drag and drop and VS 2005
>>automatically created Dataset based on the MDB schema. I found it seems
>>that all the changes are cached in the memory. Will the default way has
>>any scalability issue if the database tables are huge? What's the solution
>>if it does have the issue?
>
>