Hi,
I have an embedded database in an application. From within the
application I run "BACKUP TO" in a background thread periodically. While
this is running the rest of the application cannot seem to access the
database (it just hangs on accessing the database) and as soon as the
backup is complete all the queued commands continue through as normal. I
thought "BACKUP TO" is not meant to lock the database?.
I found this in the documentation:
"This database is multithreading-safe. That means, if an application is
multi-threaded, it does not need to worry about synchronizing access to
the database. Internally, most requests to the same database are
synchronized. That means an application can use multiple threads that
access the same database at the same time, however if one thread
executes a long running query, the other threads need to wait."
I've |enabled multi threaded mode and it has fixed my issue. Has anyone
had any bad experiences with it?|
As a side note is it the plan to have multi threaded mode by default?
and then single threaded mode just if someone wants the extra
performance? (I assume the biggest issue with not changing over is
better performance with single threaded?)
I am running H2 version 1.2.128.
Thanks,
Ryan
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
