Advice: XML file as database or table

  • Thread starter Thread starter Arjen
  • Start date Start date
A

Arjen

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!
 
Arjen said:
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!
Click to expand...

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.
 
Back
Top