I'm nearly done writing the first version of my tracking app and I'm
starting to re-think the way I store my database. Currently I have my
database setup as an xml dataset. Before I started the program I choose
to go with a dataset because I was unclear if the end user would have to
have access installed if I went with an access database.
Recently I'm starting to realize (or think) that this isn't the case.
And, from what I gather, the xml dataset is loaded completely into
memory while an access database would not be loaded completely into
memory (please correct me if I'm wrong).
I'm also not sure which is faster.
If those of you who have experience with both, or either, could
enlighten me I'd really appreciate it. From what I've seen in access c#
code samples, it wouldn't be that difficult to convert my app to use a
different type of database.
If you have different suggestions that aren't just xml or access please
also let me know.
thanks
Benny 5 2106
Access databases are not loaded completely in memory, it sounds like
your XML is. Depending on the size of your database, this could go
either way. small database would favor your xml probably, large would
definitely favor the Access db.
Larger databases lend themselves to RDBMs, such as Jet, which Access
uses as its database engine. Larger databases also lend themselves to
SQL databases.
generally, the larger the dataset, the more you would want to go with an
sql database. the smaller the dataset, the more reliably you could use
a flat-file database, such as XML. Jet (a.k.a. Access) DBs are
generally regarded as a small to mid-tier databases.
hope that helps.
Benny Raymond wrote: I'm nearly done writing the first version of my tracking app and I'm starting to re-think the way I store my database. Currently I have my database setup as an xml dataset. Before I started the program I choose to go with a dataset because I was unclear if the end user would have to have access installed if I went with an access database.
Recently I'm starting to realize (or think) that this isn't the case. And, from what I gather, the xml dataset is loaded completely into memory while an access database would not be loaded completely into memory (please correct me if I'm wrong).
I'm also not sure which is faster.
If those of you who have experience with both, or either, could enlighten me I'd really appreciate it. From what I've seen in access c# code samples, it wouldn't be that difficult to convert my app to use a different type of database.
If you have different suggestions that aren't just xml or access please also let me know.
thanks Benny
Let's say i'm storing anywhere from 100 to 1000 records (it could go
higher but I don't plan on anyone having more than 1000)
That seems small... should I go with access? is it faster? It would
save some memory i assume...
jeremiah johnson wrote: Access databases are not loaded completely in memory, it sounds like your XML is. Depending on the size of your database, this could go either way. small database would favor your xml probably, large would definitely favor the Access db.
Larger databases lend themselves to RDBMs, such as Jet, which Access uses as its database engine. Larger databases also lend themselves to SQL databases.
generally, the larger the dataset, the more you would want to go with an sql database. the smaller the dataset, the more reliably you could use a flat-file database, such as XML. Jet (a.k.a. Access) DBs are generally regarded as a small to mid-tier databases.
hope that helps.
Benny Raymond wrote:
I'm nearly done writing the first version of my tracking app and I'm starting to re-think the way I store my database. Currently I have my database setup as an xml dataset. Before I started the program I choose to go with a dataset because I was unclear if the end user would have to have access installed if I went with an access database.
Recently I'm starting to realize (or think) that this isn't the case. And, from what I gather, the xml dataset is loaded completely into memory while an access database would not be loaded completely into memory (please correct me if I'm wrong).
I'm also not sure which is faster.
If those of you who have experience with both, or either, could enlighten me I'd really appreciate it. From what I've seen in access c# code samples, it wouldn't be that difficult to convert my app to use a different type of database.
If you have different suggestions that aren't just xml or access please also let me know.
thanks Benny
With 1000 records I'd pretty much flip a coin on it. Any speed
advantage would be negligible, I'd guess. You will use more memory with
XML, but that's probably only about 10 megs or so (what size is your db,
anyway?) and on modern systems that is almost nothing.
jeremiah
Benny Raymond wrote: Let's say i'm storing anywhere from 100 to 1000 records (it could go higher but I don't plan on anyone having more than 1000)
That seems small... should I go with access? is it faster? It would save some memory i assume...
The database is pretty small... Just for fun i added 8420 records and
saved the xml file out. The xml file it generated is 5.61 MB. Of
course this is the minimalist version of each node added, but it should
show about how small these records are.
jeremiah johnson wrote: With 1000 records I'd pretty much flip a coin on it. Any speed advantage would be negligible, I'd guess. You will use more memory with XML, but that's probably only about 10 megs or so (what size is your db, anyway?) and on modern systems that is almost nothing.
jeremiah
Benny Raymond wrote:
Let's say i'm storing anywhere from 100 to 1000 records (it could go higher but I don't plan on anyone having more than 1000)
That seems small... should I go with access? is it faster? It would save some memory i assume...
First things i was trying to understand what has access or dataset to
do with access with installed on the user terminal.
If you have defined your data access layer in a generic fashion you can
connect to any kind of database. I think you have to read some articles
on how to make DAL components.
-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book http://www.geocities.com/dotnetinterviews/
My Interview Blog http://spaces.msn.com/members/dotnetinterviews/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Arjen |
last post by:
Hi,
What are the main differences between a dataset and a dataview?
What should I cache dataset or dataview... or what is the best thing to do
in what situation?
Thanks!
Arjen
|
by: Jason Huang |
last post by:
Hi,
In the ASP.Net, what's the difference between DataSet and DataView? I what
situation will I choose to use the DataSet or DataView?
Thanks for help.
Jason
|
by: Jeffry van de Vuurst |
last post by:
Hi,
I have a page with EnableSessionState=readonly in the page directive. A
couple of strange things happen.
When I try to add something to the session, I get no exception. Immediately
after adding the dataset to the session, I can view it in my Watch window.
The watch window also shows that the session is readonly. I would expect an
exception when adding something to a readonly session.
|
by: thomson |
last post by:
Hi All,
What is the difference between a typed dataset and an untyped
datset,
Where can be this used actually, I mean in which situation
which has to be used,
In case anyone has got some articles please let me know
Thanks in Advance
Regards
|
by: EMW |
last post by:
Hi,
I managed to create a SQL server database and a table in it. The table is
empty and that brings me to my next chalenge:
How can I get the info in the table in the dataset to go in an empty SQL
table?
Is there a short way like the FILL method to get data into the dataset or do
I have to read each datarow in the table and write it one at the time to the
| |
by: Lars Netzel |
last post by:
hi!
myDataSet that is fillled from an Access 2000 db and includes ONE table
From that Table in myDataSet I create myDataView and use a Rowfilter to get
a few rows that i work with (i need a DataView cause I do a lot of
filtering)
The problem is the primary key field (a unique counter), let's call it
"TBL_ID".
|
by: Lars Netzel |
last post by:
A little background:
I use three Datagrids that are in a child parent relation.
I Use Negative Autoincrement on the the DataTables and that's workning nice.
My problem is when I Update these grid and write to the database and I set
the new Primary Keys and related Fields to the new asigned atuonumbers in
the Access.
|
by: Hans Greif |
last post by:
Hallo,
hello, i try to implement a global dataset - singleton based.
On www.bakterienforum.de i found a singleton implementation:
sealed class SingletonCounter
{
public int Counter = 0;
|
by: JordanMartz |
last post by:
''' <summary>
''' Populates the DataGridView
''' </summary>
Private Sub PopulateDataGridView()
' Set the column header names.
userAccessGrid.ColumnCount = 5
userAccessGrid.RowsDefaultCellStyle.BackColor = Color.White
userAccessGrid.RowHeadersVisible = True
userAccessGrid.Name = "User Access Grid"
userAccessGrid.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.Raised
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |