i proposed to the client that we should not use the database like Access for out project. As in our application we have only one table i proposed to use a XML file.
Application will be developed in VB6.
Now what i want is that i want to use the DOM. Problem is DOM reads the whole file in memory. I do not want to read the whole XML file in memory instead i give a XPATH Query and DOM loads only selected nodes from disk to memory. Then i want to do operation like add a new record, modify and delete record and still i do not want to load the entire XML file in memory.
Here is what should be the XML database file format
<Table Name = " ">
<Record ID="3"> i want only one record
<field1 value=""> to be load in DOM
<field3 value=""> also i want to modify
</Record> this record in the file
I ALso want to delete
this record from XML
----------and so on-------------
-----More tables in future here----------------
I think file will grow 200K each month by added new records. So loading the entire file in memory will not be acceptable solution after say 1 year.
I will also conside if there is a samll XML database available on the internet. PLease suggest free tool