a question for typed dataset
-
Hello ! i'm new in vb.net.I have to create a project and i have a question : i'm thinking to use typed dataset.The database is on another computer in network (sql server 2008).The database has 20-30 tables and will grow not much (10-20 mb on every year) is true that the dataset keep a full copy of original database on my computer or only the database schema? ( i have read several articles but i don't understand this).is this a performance problem for my situation or no? Thank you in advance.
-
Hello ! i'm new in vb.net.I have to create a project and i have a question : i'm thinking to use typed dataset.The database is on another computer in network (sql server 2008).The database has 20-30 tables and will grow not much (10-20 mb on every year) is true that the dataset keep a full copy of original database on my computer or only the database schema? ( i have read several articles but i don't understand this).is this a performance problem for my situation or no? Thank you in advance.
Have a look at this Article, first example for SQL Server ADO.NET code example[^] As you can see you take as much data as you require for the operation and not the entire database.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
-
Hello ! i'm new in vb.net.I have to create a project and i have a question : i'm thinking to use typed dataset.The database is on another computer in network (sql server 2008).The database has 20-30 tables and will grow not much (10-20 mb on every year) is true that the dataset keep a full copy of original database on my computer or only the database schema? ( i have read several articles but i don't understand this).is this a performance problem for my situation or no? Thank you in advance.
dcode25 wrote:
is true that the dataset keep a full copy of original database on my computer or only the database schema?
No. It only holds the data that you retrieve. Copying an entire database would be very performance prohibitive. What if the DB has 4GB worth of data in it? Or a single table for that matter? How long would it take to copy all that data? The dataset will hold an internal schema of only the columns that you retrieve. That information is lost when the dataset goes out of scope.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
dcode25 wrote:
is true that the dataset keep a full copy of original database on my computer or only the database schema?
No. It only holds the data that you retrieve. Copying an entire database would be very performance prohibitive. What if the DB has 4GB worth of data in it? Or a single table for that matter? How long would it take to copy all that data? The dataset will hold an internal schema of only the columns that you retrieve. That information is lost when the dataset goes out of scope.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Thank you ! But why on internet there are many articles that describe the performance problems on typed dataset.i read that typed dataset hold an offline copy of database.Now dataset holds only the schema or with all the data ?
Neither holds an off-line copy of the database. I have no idea where you got that from. The typed datasets are there to make it easier for new people to work with databases. Frankly, I find them to be a huge pain since they have such a large overhead and they hide much of the work that goes on with databases.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Hello ! i'm new in vb.net.I have to create a project and i have a question : i'm thinking to use typed dataset.The database is on another computer in network (sql server 2008).The database has 20-30 tables and will grow not much (10-20 mb on every year) is true that the dataset keep a full copy of original database on my computer or only the database schema? ( i have read several articles but i don't understand this).is this a performance problem for my situation or no? Thank you in advance.
if you are storing large amount of Data in DataSet then it will take lot of memory. DataSet can have the Data as well as the structure and the relation between the data.