> Does your flat file support ACID transactions? That´s the killer feature fo > my app. I want to store financial transactions and I don´t trust normal flat > files. No it isnt acid, its not got critical information in it but it does need very fast read access and write access that doesnt block reads.
But this is one of the reasons why we are investigating SQLite, we want a bit more resiliant data storage but also the flexibility that a quick query engine will give us ... Searching for a specific word in all of the records (300k) isnt very quick but with SQLite would be much quicker and more flexible.