My application generates about 12 records a second. I have no problems
storing the records into the database, but started thinking that if I
commit every 12 records, will my hard drive eventually die to extreme
usage? During a 24 hour period up to 1 million records will be
generated and inserted. At the end of the day, all the records will be
deleted and the inserts will start again for another 24 hours.
Can I store the records into memory, or just not commit as often, maybe
once every 5 minutes while still protecting my data in case of a PC
crash or unexpected shutdown due to user ignorance?
Does anyone have any ideas for this type of situation?
Nathan Biggs
