"jason weaver" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > However, due to database locking issues, I need to do a bunch of > inserts in one transaction or batch. Thus, I store them in a simple > queue. Therefore, the julianday('now') won't work because all of my > batch inserts will have the same date and time. And that doesn't > work very well. ;)
You will have to deal with this in any case. E.g. on Windows the system timer resolution is 15ms by default. You can insert quite a few records in 15 ms. It is unrealistic to expect that every record could be inserted with a unique timestamp. Find some other way to ensure uniqueness (e.g. just assign a sequential number to each). Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users