markhad
09-10-2011, 05:21 PM
I am writing a database. It consists of 'orders' each of which has around 25 fields (addresses, emails etc etc). There will be up to 100 open orders at any one time. I plan to have the data stored in XML. I would have one XML for these open orders which I can write to file using SWFKit.
I would also like to archive the closed orders which could number in the thousands. Is it good practice to have all of these in another single XML file or should I split them - ie monthly or every 100 etc? I am worried about the data becoming corrupted and losing too much.
I would also like to archive the closed orders which could number in the thousands. Is it good practice to have all of these in another single XML file or should I split them - ie monthly or every 100 etc? I am worried about the data becoming corrupted and losing too much.