Roundup Tracker - Issues

Message659

Author proff_fs
Recipients
Date 2003-03-05.11:24:30
Message-id
In-reply-to
Logged In: YES 
user_id=18721

In sqlite (and other SQL databases) a transaction needs to be 
started with BEGIN, and be finished with COMMIT or 
ROLLBACK. Currently it seems (after a brief source scan) that 
all SQL statements are just send to the database, but in that 
case sqlite creates mini transactions for each change and 
effectively writes all changes immedietly. A solution might be 
to send a BEGIN when the database is ready to receive SQL 
commands and after each COMMIT and ROLLBACK command. 
Then the current assumption, that COMMIT and ROLLBACK 
work on everything since the database is open or the last 
commit/rollback was issued, would be correct.
History
Date User Action Args
2009-02-03 14:20:15adminlinkissue689383 messages
2009-02-03 14:20:15admincreate