Database cleanup

Just wanted to throw this out may have already been discussed. Why doesn't linden create a closet for each user? I describe this as a separate database to store rarely used items that can easily be retrieved back to the main database when needed. I figure most everybody has 1000's of item they rarely use but want to keep such as Christmas decorations that load down the database. I would think if even half of the almost 1.7 million users used this feature the size and load on the main database would be reduced significantly. Thus allowing for improved load and search times plus greater database stability. With the second database onsite it would not require more bandwidth to the outside and worst case if everybody accessed his or her entire closets at once we would just be like we are now. Only rule would be it would need to operate like the folders do now to allow for easy search and retrieval when needed.
What do you all think am I crazy lol ?

All it would do is move the problem elsewhere. It wouldn't solve it. You'd still need a database server to keep track of all the stuff, and complexity of the interface would be increased, as well as the internal server traffic. You'd save nothing.

This is what folders in your inventory are for - to help you categorize your stuff. Failing that, I can create container objects and move all that extra stuff into those, and pick the container objects up again. Now I have single objects in my inventory that contain all 627 variants of plaid golf clubs with tassles I have cluttering up my inventory taking up space, another for storing all those gasoline powered turtleneck sweaters, and so forth. W00t!

Of course, may the gods help me if I lose that one box with all the plaid golf clubs, but that's a separate issue.

An 'archive' would be very cool... but by making it searchable means there's no real peformance win to doing this.

You can create your own "Z - Archive" folder and stuff things there. (Why "Z -" at the beginning? So that when you search for things it won't list matches in your archive first!

We do have an 'archive' capability of sorts... putting textures into 'texture organizer' objects rather than keeping them stored independenly in our inventory, which can help with the speed of loading our inventory after log in.

I get the impression that the inventory database is merely an incredibly long list of asset uuid's pairs, owner info and a permissions bitfields.

An asset, (like a common texture or animation) probably exists in many inventories. Can't move assets into "archive asset storage" to offload the asset server unless *ALL* people and objects archive it. A task so icky that the cost of trying it would probably outweigh all the benefit.


Another thing you could try is setting your Recent Items tab to be the last few months. Your main inventory tab would be everything + archive, the recent items tab could then be the inventory you use normally.

Just trying to figure a way to reduce the database think of how much stuff is in there for the 1 million that haven't logged on in the last 60 days there has to be a way to move it off the database without deleting it with the ability to bring it back . Doesn't every item in your posession require some space in the database to reference it?

Which is exactly what happened to me on update day... well except for the part about golf clubs... replace that with textures I'd carefully categorized as "Fabric" and placed into an Organizer box. I had done the same thing for metals, wood, water, etc.
I tried to rez that "fabrics" box on my own land and it went *POOF*. Never rezzed and never returned to inventory (it had a few no copy textures in it) Tech support said if it doesn't show up again on its own then its gone. It hasn't shown up. I have postponed emptying my trash this whole time, just in case.
I thought I was smart and doing my duty to keep my inventory low, but now i know better.