PC Review


Reply
Thread Tools Rate Thread

Advice: XML file as database or table

 
 
Arjen
Guest
Posts: n/a
 
      11th Feb 2005
Hello,

If I choose to use a database then I need to use multiple tables. With a XML
file I can select "my objects" as once. I think that there will be around
10.000 records (objects).

I want to select my objects on different (selection criteria) ways (on
attributes). And I want to add, update and delete my objects.

Can somebody tell me if it is a good idea to use a XML file as database or
table?
Can I read parts of a XML file (for paging purpose)? Or do I need to select
everything at once?

Thanks!


 
Reply With Quote
 
 
 
 
Hans Kesting
Guest
Posts: n/a
 
      11th Feb 2005
Arjen wrote:
> Hello,
>
> If I choose to use a database then I need to use multiple tables. With a XML
> file I can select "my objects" as once. I think that there will be around
> 10.000 records (objects).
>
> I want to select my objects on different (selection criteria) ways (on
> attributes). And I want to add, update and delete my objects.
>
> Can somebody tell me if it is a good idea to use a XML file as database or
> table?
> Can I read parts of a XML file (for paging purpose)? Or do I need to select
> everything at once?
>
> Thanks!
>
>


If you use an XmlDocument, the entire file will be in memory. If you
change anything you need to rewrite the entire file.
It might be better to use a "real" database for this.

--
Hans Kesting
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link a table from database protected by mdw file Alek Luchnikov Microsoft Access Form Coding 15 10th Mar 2007 11:09 AM
How to link a table from database protected by mdw file Alek Luchnikov Microsoft Access Getting Started 15 10th Mar 2007 11:09 AM
how to import a csv file into database table using vb.net Rnt6872 Microsoft VB .NET 4 10th Feb 2007 01:37 AM
Code for delete Table from other Database file =?Utf-8?B?S0sgQ2hhbg==?= Microsoft Access 2 27th Sep 2005 07:59 PM
Copy data from one table to another in the same database file in . =?Utf-8?B?Q29sbGV0dGUgRm94?= Microsoft Access External Data 2 13th Oct 2004 01:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:40 AM.