Vendor Search Timing Out
Ok, who forgot to index the database? Simple searches are timing out on all shards. Just tried three shards for a single word and all timed out.
Looks like someone needs to update statistics on the DBMS or something. ASAP.
Looks like someone needs to update statistics on the DBMS or something. ASAP.
Comments
Seriously. Index the database already. Do you need help? This is like data management 101.
Please for the love of everything UO......Please please PLEASE figure out what the problem is and fix it. It would be an AMAZING asset if it worked properly.
this is no coincidence that only after the Castle contest started that VS went crazy.
you can also notice that at least 3x last week uo.com was down , so they are having some sort of database issues.
so here we will suggest again and again and again.
@Bleak ; why not create 2 different Vendor Search?
1 Just for regular vendor
1 just for auction safes
i believe by having 2 databases will make the search easier?
but yes, to the main topic, it is impossible to use VS now, sometimes you search today and the next day while you doing something total random the window will pop out of nowhere with the result, even while you hunting or pvping
I think you might be thinking the opposite of what the message is telling you. You are saying you are only typing in one word which is the exact opposite of "refined" (you are broadening). The message is telling you to give it more detail; not less (ie 1 word). For example if you are looking for some armor legs for your mage and just type in "armor" or "legs" it's going to be sorting through hundreds if not thousands of items. Refine your search. That means maybe type in "leather legs" (if that's what you want) or add some stats on there that you want which will further refine it.
I've found that most (not all) of what I'm looking for will find MUCH more success by using the option boxes rather than just typing in something. So if you want a tangle; instead of typing in "tangle" just select "Belt/apron" slot and then go to stats and enter 10 Int. Click search. It will return results pretty quick. There will be some items that might be hard to do this with (EM items w/ no stats etc) but for the most part this will get you what you need 80% of the time outside of ATL.
Try alacr detect or trans detect. For scrolls do scroll detect and you will get all 3 if they are there, PS/Alac/Trans.
Scroll of alacrity always helps to use the actual name (ie "Detecting Hidden"). I just did this search on Orgin (assuming your shard) and within 10 seconds it says no items matched my search.
On the Easter items; you don't really have specific thing so I can't really help you narrow it down there but again if you want an "Easter Egg" that is what you should be writing; not just "easter".
It started timing out a few weeks ago on all shards. Right now on LS you can do any search and it will time out and the results will show up about 10 minutes later. Unless you try searching over and over, then the results will show up every 5 mins or so for as many times as you tried.
Some days it works everywhere without issues.
So use a toon sitting at a bank. Do the search and if it times out, leave him still until the search appears, then grab the scrolls to go to the vendors.
Lots of Easter Baskets. Also every item I could think of, I went and looked. They all have the word Easter in them,
The floating Valentines candles and the picnic baskets are also kinda Eastery.
Origin has like...9 vendors lol, so of course it works there
Geese and Dragon Eggs are 200k.
I want some more of the little chocolate Bunnies, those are cool to place around your house.
I am on earlier than normal. I am usually on at 6pm C. Check Atlantic at that time if you are so sure it works. But also I check daily. I am about finished running guys around from the artisan festival. Been looking for things to bring back home on many shards every day.
It does work some times and does not work sometimes. You do not use it as often as I do.
LMAO
It works Great!
When it is working I do this and put "scroll 110" or whatever size I want and it works.
Oh ok... 45min later it does work when you tested it... but... anyone that says it works just doesn't use it much...but you use it more than anyone...
Error. Error. Cannot compute. *head explodes due to the infinite loop*
Why don't you go to Atlantic and show it working instead.
It also does not work on small shards at times.
I can not help the fact that it works sometimes and sometimes shows the results 5 mins after it says it timed out. I have no control over it, I just use it a lot.
If you need DBA help let me know. Its been awhile but not that long since I used to consult DBA's.....
I mean , come on, 2 years that WE been asking and NOTHING.
It is very annoying the silence about this ISSUE, yes, It is an ISSUE.
ask them about hosue placement Scripting on atlantic
It began happening as soon as I patched up. So that seems to have been the catalyst.