<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Han,<br>
<br>
Do you mean that you want to clear the objects, etc. from the
database or just from the region instance?<br>
<br>
Others have described various methods to remove items from a region
in this thread, but the removing objects from the database has more
subtle issues.<br>
<br>
One of the "todo's" for Opensim is a way to clean/prune "orphans"
(unused items) from the database - there is simply no mechanism to
do that directly yet. I would happily write an SQL macro to do this
pruning, but it is far beyond my SQL skill level!<br>
<br>
The way the database is designed is to store the largest part of an
object's description once then refer to that via GUID indexes. As a
result 10 (or 10,000) copies of an object takes only minimal extra
space in the database. A few minutes exploring your database with
SQL admin tools should show you how this all works.<br>
<br>
About the only way to "clean" the database at present is to save
every region and every avatar's inventory to IAR/OAR files, delete
the database and restore the information from the IAR/OR files.<br>
<br>
This is not a huge problem for most OpenSim grids as yet since most
grids are fairly small and in addition the database contents must be
reloaded whenever there is a major upgrade to the software (e.g.
0.6.9->0.7.0)<br>
<br>
The only time this duplication of objects does become an issue is if
you frequently use a viewer based restore (Imprudence save/restore
or the like). The viewers do NOT check to see if the
object/inventory already exists, but simply creates a entirely new
entry in the database for each item. Restoring a large region or
inventory several times is often necessary due to errors, but all of
the earlier bad and partial restores are permanently saved in the
database. With an experimental region this can cause the database to
get huge even with only a dozen or so objects actually being used! <br>
<br>
Second Inventory does check for objects which already exist in the
database and this has been about 80-90% effective in my experience.<br>
<br>
The only truly "foolproof" method to save and restore items in the
database is the IAR/OAR files which use a completely different
method to save/restore the database items. <br>
<br>
Conclusion: When possible always use the IAR/OAR files and plan to
reload your database periodically.<br>
<br>
I hope this helps<br>
<br>
Karen<br>
<br>
On 02/26/2012 09:52 AM, Han Xu wrote:
<blockquote
cite="mid:CAOyqe5yEmRscARF=5crmdFvDV-N16kc2CszgUsEZQJn7jG_gUw@mail.gmail.com"
type="cite">hi all,<br>
<br>
after playing the region for some time, there are a lot of
experimental stuff in the region. is there a way to clear all
those prims? or just reset the region to its initial status?<br>
<br>
thanks!<br>
han<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
</body>
</html>