> The question following your suggestion is how do i maintain transaction > start and stop times? I have no control of knowing when a transaction > starts and ends and i said earlier, i cannot use transaction hooks.
And you didn't answer my question: how will you put this transaction identifier into tables? How will you know which transaction each INSERT or UPDATE belongs to? Pavel On Tue, Jun 22, 2010 at 6:55 PM, b s <gaiet...@yahoo.com> wrote: > Hi, > Blob was just an example. My original email said hex(randomblob(16)) > as a means of generating an uuid. It is not the important part. > > The question following your suggestion is how do i maintain transaction > start and stop times? I have no control of knowing when a transaction > starts and ends and i said earlier, i cannot use transaction hooks. > > thanks > brs > > > ----- Original Message ---- > From: Simon Slavin <slav...@bigfraud.org> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Sent: Tue, June 22, 2010 3:45:26 PM > Subject: Re: [sqlite] marking transaction boundaries > > > On 22 Jun 2010, at 10:25pm, b s wrote: > >> I want to mark that the following records inserted or updated >> belong to a certain transaction. > > Transactions can be nested. In other words, an INSERT or UPDATE can belong > to more than one transaction. BLOBs are hugely expensive in terms of > programming, processing time and storage. It would be far less 'expensive' > to mark your transactions with INTEGERs. > > If you have your own description of what a transaction is, just use a trigger > to maintain a 'last updated' field for every row, and make a table which > lists your transactions and their start and stop times. > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users