[Opensim-users] bin/OpenSim.db-journal file begin written and deleted many times

[Dahlia Trimble]

Translate scene should complete quite quickly, all it does is move the
objects in the scene. What you are probably seeing is the changes being
saved to the database, an entirely different process. If you are using
Sqlite for your region database than storing changes to the scene will
always be quite slow. It would likely take just as long for loading an oar
with the same number of objects and saving them to the database. If you
need faster region storage, try using one of the other database options
such as mysql.


On Mon, Apr 28, 2014 at 4:43 AM, Ai Austin <ai.ai.austin at gmail.com> wrote:

> As I shutdown a region simulator, I see a lot of flashing of an open
> window showing the directory listing for the bin directory.
>
> This seems to indicate that a 5K file called "OpenSim.db-journal" is being
> created and immediately deleted a LOT of times as the OpenSim.db file (for
> SQLIte data base) is changed. At least that's what I assume is happening.
>  A translate scene command on a region with only 600 objects seemed to take
> nearly half an hour to complete on an otherwise unloaded region yesterday
> for example, and this flashing wad happening throughout until the system
> finished its "shutdown".
>
> This seems to be enabled  by the default level of debugging and I wonder
> if this could this be a source of a slow down in using OpenSim?
>
> Can anyone shed light on what is happening here and if the default logging
> might itself be a cause of why such operations take such a log time?
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at opensimulator.org
> http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20140428/f7c380eb/attachment.html>