App data storage on PocketPC
-
Hello, I am trying to determine the best option for storing locally-created data for a PocketPC financial analysis application. I have skimmed several books on PocketPC development, and searched the web and various newsgroups for opinions and guidelines on using flat files, binary files, ADOCE, SQLCE, XML, and other options **for local application data storage**; but have found little to crystalize my thinking/decision-making. The application is currently implemented using the basic FileSystem/File control with simple sequential operations. However, as I extend functionality, the data storage requirement expands accordingly - resulting in degrading app performance. So, I thought I would appeal to the PocketPC developer community for some assistance. I appreciate any thoughts on the subject. OK, here are some app details: 1) Financial analysis application where the user currently enters 60 - 200 inputs that need to be stored on the PocketPC 2) The data can be grouped into 5 generic categories, each containing 12 - 40 data entries 3) Need to support exporting of user entered data, and approximately 320 app-generated result calculations (for importing into Excel /MS Office apps on desktop PC) -- a total of 380-520 data items per exported file. 4) Snappy performance when loading and saving data files is desirable 5) The solution can employ either multiple files for each analysis (e.g., user data file + app results file + app export file that combines user data and app results) or a single file containing user data and app results Thanks in advance, Donovan Dillon.