Advice: XML file as database or table

[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!

 

[Hans Kesting]

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.