Adolfo: I can't tell you how many times I felt a flat file approach would be better. However, 2 years ago when the design began there was a thought of 'Having the ability to mine data on the device would be an invaluable tool'. SQLite has proven superb for some aspects of the system, but not for storing simple flag data.... I believe someone name Occam had something to say about this? Ah the benefits of hindsight.... (sorry for the sarcasm, its the only thing that keeps a smile on my face).
Ken: >How do you decide which 20% to clear incase of space treshold? Oldest 20% is cleared once a max size is reached. Its kinda arbitrary... I just figured it was better to clear a large swath of flags than a delete one, insert one approach. >Is the downloaded data always deleted once successful? Yes Woody: Good to know, thank you :-). _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
