Hi, I did a little test with a fresh OpenSim installation (yes, thanks for the installer!), to get a grip on what I learned from Melanie yesterday.
I wrote a little python script to help me monitor these tables: inventoryStore/inventoryItems assetStorage/assets http://pastebin.com/mc9e6574 , be warned: ugly code. I started OpenSim and logged in a 'Test User' with the SL viewer. (Just to mention it - first time log in in as test users creates 4 'blank' entries in assets.) The inventoryItems table was initially empty. Now I rezzed a cube and renamed it to 'p1'. inventoryStore/inventoryItems was still empty. To my surprise no new entry shows up in assetStorage/assets. Picking up the cube ('take') created an entry named 'p1' in the inventory and in the asset table. Now I renamed the cube in Test Users inventory to 'p2'. The name in inventoryStore/inventoryItems changes to 'p2'. The entry in assetStorage/assets stays 'p1'. As mentioned on the list before, the asset name is useless, since the user only sees the name in the inventory. Now I deleted 'p2' in my inventory - 'p2's parentfolderID changes to 'Trash'. Now I emptied the trash - the inventory table is empty again, which is fine, but here's the big one: the assetStorage/assets still holds the reference to 'p1'. Just to make sure I shut down the simulator and opened it again, and it was still there. Now, doesn't that mean, that the database increases over time with no hope to find these assets that actually should be gone? or is there some magic purging that happens, and that I missed? This would mean that any grid runs into a severe problem over time. Best, Dirk/Bart _______________________________________________ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
