Apologies for multiple posting - these extra copies were sent from googlemail.com, whereas I has subscribed to the list as gmail.com.
Chris. On Aug 19, 8:35 am, Chris Dew <cms...@googlemail.com> wrote: > http://www.sqlite.org/lang_savepoint.html > I'm looking for a datastore with the following properties: > * I need to 'mark' the state frequently (sub second interval). > * I need to be able to revert the datastore to a previous mark (with no > appreciable delay). > * I only need to keep the last few hundred 'marks'. (i.e. I never need to > revert to a datastore marked more than a few minutes ago.) > > The savepoint functionality in sqlite looks to almost fit the bill, but its > savepoints seem to be nested - i.e. you cannot 'forget about' old savepoints > while retaining recent savepoints. Is my understanding correct here? I'm > concerned that this would cause a performance issue when millions of nested > savepoints have accumulated. > > Obviously I can roll my own data structure here, but is sqlite was feasible, > it would be good. > > Does anyone have any suggestions? > > Thanks, > > Chris. > _______________________________________________ > sqlite-users mailing list > sqlite-us...@sqlite.orghttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
