VS not working at all today @Bleak

Comments

• Arnold7 Posts: 1,404

  May 2

  Seems ok on Great Lakes earlier this morning.
• Theo Posts: 199

  May 2 edited May 2

  Likely there is a database behind vendor search. Atlantic has probably 20-30 times more items than GL.  The database is likely poorly indexed for the most part.  When you run a search it executes a query against the db. If it doesn’t hit indexes it will table scan. Takes far further for Atlantic items than GL. There is likely a query timeout set so long runaway queries don’t crush the db.   When it hits ATL with a table scan it times out.  

  
  

  First the search field should only search the item description not all the fields of the item. Example if you search for swing speed increase you get every field searched for swing speed increase. Hugely inefficient.  If you use the menu to search for property swing speed increase 1% or higher - it will hit an index.   

  
  

  The query function here is sorely lacking.  On low pop shards with low item counts it works fine. Atlantic is always troublesome. It’s not efficient nor is they way they are querying for items. It needs an overhaul. A better UI and some better filters and indexing would be hugely beneficial. 

  
  

  Give me the DB and a couple weeks of developer time and I’ll fix it forever.