News Archive: Week 15, 2016

It's never to early (or late) to <a href=https://subeta.net/explore/fragmentizer.php?act=shop>celebrate mom!

Note: You can now frag items r101 and r150! We've also added a special rarity for currency items so you don't accidentally frag those!

Below you can find the FAQ, which is also posted in the Gold Account forums, for the new User Shops Beta Testing. We will continue to add on to this as needed based on frequent questions from the original news post, the site feedback thread, and the Beta Testing thread.

FAQ

Why do we even need new shops?
User shops have been bogging down the site for years. They are the single biggest resource hog that we have, often taking up 25%-40% of the database's entire server load. A big part of this is that the shops were never designed to hold as many items as they do now. The database tables are badly indexed, and badly optimized for the data they're holding, and there is simply too much in them to even try to fix those problems. Starting over from scratch allows us essentially a blank slate without those problems existing in the first place. The new database tables and code have been built with modern practices and will scale better to the amounts of information they will hold.

The reason we're doing something about it now is we believe the user shops have been causing huge bottlenecks in our database, and are a major reason for the 502s and 504s of late.

How will changing the shops help with the lag? Because of the new limits, everyone will be piling items in their vaults, so it's just displacing the problem and not solving anything.
User shops exist on a table, and when you "write" or "edit" a table, it has to "lock" so that information is preserved. If you update the price in your user shop, or an item is purchased, or any type of edit on the table, the entire table has to lock for some amount of time, which means that the next query (looking up items, also purchasing an item, etc) gets put a few milliseconds behind until the first one is done. These pileup and you end up with 5-6 seconds for a query to finish, or sometimes 30+ seconds, which is where the errors happen because the servers timeout waiting on the query to finish.

This doesn't happen with vaults, or wardrobes, because there aren't nearly that many things on the site hitting them. People aren't frequently updating the price of items in their wardrobes, frequently adding/removing items from them, or anything like that. Vaults aren't used when we release a new feature, or when quests are changed, or whatever the case is that people rush to buy things from user shops and everything starts crumbling. Vaults don't currently have a processing time of 3-4 seconds on updates that hang the entire server process, etc.

Item limits??
We've been warning these were coming for years, and they're finally here. But, as mentioned in the news post, we anticipate these initial limits will be raised quite a bit before we settle on final numbers. And even after they're "final" there's always the chance they could be raised again in the future.

We’ve started with lower numbers to start testing, because it’s a lot easier to start of small and increase as we test rather than start off with large limits and have to decrease as we go!

How do I get to the new shops?
Glad you asked! You can start making your own shops here, and the new shop search is located here. The new shop search will include results from both the new and legacy shops (until the old shops are disabled), so if you want to be sure you're getting the best prices, you should use it!

Is beta testing safe? Will I lose my items?
All of the basic functions have been fully tested by staff members, and all of your items should be perfectly safe. That said, if anything goes wrong, please post HERE to tell me what went wrong, and file a ticket. Everything is being logged and a UA will be able to help you.

Will there be a way to move all of my items from an old gallery to a new one?
We're talking about this behind the scenes, trying to come up with a solution, but right now there is no easy solution for it. For example, how to transfer an old shop to a new one that is bigger than the new item limits. Or simply how to move the items without killing the database.

We agree that it's a very important issue, and we will come up with a solution that we hope fits everyone's needs. In the meantime, access to your items in old shops and galleries will never go away, even after the shops themselves are disabled.

Do I need to move everything right away?
No! You do not have to have your transition complete by the day we expect the new shops to go live. Your items will still exist. You can move them out and to your new shops at your own pace.

If I'm reporting a bug, what information should I include?

1. The page the bug occurred on
   
2. What happened, to the best of your knowledge
   
3. Can you reproduce it (ie can you cause it to happen again by doing the same thing)?
   
4. Steps to reproduce, if possible
   
5. The browser and version that you use
   
   Please leave all bugs you find HERE on the Beta Testing thread in the Gold Account Forums.
   
   Okay but what’s being done about hoarding items?
   and I have a few things to help discourage hoarding and give users more reasons to use their items in more ways, though you don’t have to if you don’t want to. Our immediate plans include allowing more items to become fraggable and looking into the Recycle Beast (mostly ways to make it easier for people to recycle things to him). Users have been coming up with great suggestions, like making a food day where you can feed as many foods as you can to a pet or just making pets get hungrier faster. Don’t hesitate to post your own ideas! Not all of the suggestions listed HERE are uses for items, some are for unique ways to display items (like toys your pets have played with).

We've been a bit swamped around here getting the spring cleaning started. Enjoy some more revamps!

Thraix the Reborn Lain has won the Pet Spotlight!

Cinthia's Quests is the weekend quest! Do those quests for increased prizes and special rewards!

Attention, Gold Account users! We have a new feature for you to test--revamped Shops and Galleries!

The user shops and galleries have been rewritten because they currently put a huge stress on our database, and it's affecting the ability of the site to function.

For the new shops and galleries, we’ve set limits for how many items you can have in each, which means we’ll be retiring the Super Shop! and Hoarder! achievements. Currently the limits are as follows: you can have 250 unique items in a shop, and 500 in a gallery. This limit doubles to 500 in a shop, 1000 in a gallery if you have a Gold Account. These limits are only for unique items, you'll be able to have as many duplicates as you'd like.

Your items won't disappear if your Gold Account expires while over the limit, you just won't be able to add any more until you have either sold/removed enough items or have an active Gold Account again. You can have up to 3 shops/galleries, or up to 6 with a Gold Account. We anticipate being able to raise these limits significantly, but we wanted to start off small and increase rather than starting off big and having to reduce it.

Gold Account testing for will be active until 11:59pm on April 16th. The new user shops/galleries will be released to everyone on the 17th. Once the new shops are live, you will not be able to add anything new to your old shops!

On April 24th, all old shops will be disabled. You’ll still be able to remove items from them, you just won’t be able to reprice items or have other users purchase from it.

The Super Shop! and Hoarder! achievements will be retired on the 17th once the shops/galleries go live for everyone.

Information and a link to the new shops can be found here if you're a Gold Account member. will start pushing changes/fixing bugs on the 13th, so keep that in mind as you submit feedback. We will continue to make any necessary changes once shops/galleries are live for everyone to make sure they’re working to their full potential!

We know this will be a big change for a lot of people, but it's a crucial step for the continued improvement and success of the site, and for your overall user experience.

Froseti the Glade Kumos has won the Pet Spotlight!

The galactic tigrean has been revamped! You may not be able to hear this big kitty roar in space, but you should still keep away from those glistening teeth!

Visit the Coda Caves today and tomorrow to collect gems, which you can then take to Iltallo in order to bless your pet with the galactic color.

Death Eater the Nightmare Neela has won the Pet Spotlight!

A familiar <A href=https://subeta.net/explore/gift.php>gift has sprouted up again!

The Masquerade Forums have been closed until next year.

The items from the 2012 tab in the Steamworks Menagerie have been retired.

Migrating Masks will be restocking for the rest of April!

Kahrmuh the Custom Galactic Montre has won the Pet Spotlight!

Are you unlucky when it comes to trying to grab a Genderless Berry from the Blackheart Hollow? Fortunately for you, the Millionaire Center now has Genderless Berries available.

Note: The Genderless Berry has not been removed from the Blackheart Hollow stock, so you can still try to grab it from there if you feel the price is too expensive for the Millionaire Center!

Hello! We are taking the opportunity to update our database system. The process is fairly easy, but the site needs to be down during this time. In order to update the DB, we are scheduling some downtime for Wednesday, April 6th, at 2:00 AM EST. Projected downtime is estimated to be around six hours.

It’s time to hang up your dancing shoes until next year because the Masquerade is now over.

The forums are still open, but they and the items in the 2012 Menagerie tab will go away today at 11:59pm!

Kwikspell the Common Experiment has won the Pet Spotlight!