Quote:
Originally Posted by Tech Manager
As an added note, if I am gathering copious data I am probably not going to rely on a flat file (text file) to store the data. I will usually store data in a customized database so I can review live data on the fly, generate reports, graphs, etc.
|
What type of database do you find most efficient for storing the records? Do you use a seperate light database app on the server, or a simple table under your existing database engine, or some other type of solution?
It sounds like whatever solution was implemented would have to be very low on overhead so that new entries could be created with minimal resource impact, overhead from dynamic solutions such as relational features would be eliminated to minimize total file size, but enough power to collate the data for searching and reporting functionality. It would also have to be very efficient for handling a narrow table with few fields but many records.