Hi all,
fixed in assp 2.2.2 build 12345:
- If a transactional database was used and the database driver option
'autocommit' was set to '0' (default is '1')
(like DBdriver:=mysql,...,autocommit=0,...)
assp has not executed the 'commit' statement after adding or changing a
record - nor the 'rollback' statement
in case of an error - which possibly caused unexpected crashes of the
Perl process.
changed:
- If 'mysql' is used as database, assp now reduces the count of submited
SQL-statements for inserted and updated
records.
Instead the mechanism ' EXISTS ? UPDATE : INSERT ' - the mechanism '
INSERT ... ON DUPLICATE KEY UPDATE ... '
is used.
This keeps the mysql IX-record-lock until the operation has been
finished and it keeps the data consistent in case
the same record is added or changed by multiple threads at the same
time.
Thomas
DISCLAIMER:
*******************************************************
This email and any files transmitted with it may be confidential, legally
privileged and protected in law and are intended solely for the use of the
individual to whom it is addressed.
This email was multiple times scanned for viruses. There should be no
known virus in this email!
*******************************************************
------------------------------------------------------------------------------
LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial
Remotely access PCs and mobile devices and provide instant support
Improve your efficiency, and focus on delivering more value-add services
Discover what IT Professionals Know. Rescue delivers
http://p.sf.net/sfu/logmein_12329d2d
_______________________________________________
Assp-test mailing list
Assp-test@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/assp-test
