test content
What is the Arc Client?
Install Arc

Please don't initiate AH search until Search or Sort a column is clicked

eldartheldarth Member Posts: 4,494 Arc User
edited December 2013 in General Discussion (PC)
The AH is overburdened enough.
It submits/retrieves search data so many extra times it takes me a couple of minutes to get to the actual search I want.

For example....
  1. Click Category --- search/result 30sec
  2. Click Type within category --- search/result 30sec
  3. Click Sort by expiration -- FINALLY the search/result desired.

The first 2 search/results are worthless net traffic from EVERYONE using the AH.

Submit search on Search Button, or Sort column ONLY.
Post edited by Unknown User on

Comments

  • snottysnotty Member, NW M9 Playtest Posts: 476 Arc User
    edited December 2013
    ok, I'll change how I use the AH to make your life easier.
  • walk2kwalk2k Member Posts: 928 Arc User
    edited December 2013
    why does it even do another db req just to sort the list? it should cache the entire req and sort in the client! so stupid, it takes THREE db hits to see items sorted by lowest buyout (because the 1st click shows you the HIGHEST buyout - who in the HELL would ever want to do that anyway??) no wonder it's so slow
  • eldartheldarth Member Posts: 4,494 Arc User
    edited December 2013
    snotty wrote: »
    ok, I'll change how I use the AH to make your life easier.

    You've got no control over it -- It's the way Cryptic automatically searches on every single thing you click which is pathetic.
    Bad programmer bad! No cookie for you!
  • eldartheldarth Member Posts: 4,494 Arc User
    edited December 2013
    walk2k wrote: »
    why does it even do another db req just to sort the list? it should cache the entire req and sort in the client!

    Actually, no - that part they got right -- results are paginated so client/server doesn't have to send the entire 1,000+ result items to the client - it only sends a "page" worth - 30 or so.
  • denverralphydenverralphy Member, Neverwinter Beta Users, Neverwinter Guardian Users, Neverwinter Knight of the Feywild Users Posts: 145 Bounty Hunter
    edited December 2013
    I agree... with the lag in the AH as bad as it is...

    Allow us to set up our search terms, the type of item we're searching for, and the sort order, and only then search based on our criteria after clicking search.

    It's so annoying when you finally get your search criteria setup, only to get the "Too many recent searches, you must wait X number of seconds." because it searches every time you click on a sort order. And that's even when the AH isn't lagging (rare lately).

    As well... there should be disqualifiers in the search terms... if I want to search for "plaguefire" enchants, but don't wish to see a bunch of clutter like "lesser plaguefire" in the results... I should be able to search for "plaguefire -lesser" to filter out all the garbage "lesser" items. (not to say Lesser Plaguefire enchants are garbage... just that they're clutter when that's not what you're looking for)
  • walk2kwalk2k Member Posts: 928 Arc User
    edited December 2013
    eldarth wrote: »
    Actually, no - that part they got right -- results are paginated so client/server doesn't have to send the entire 1,000+ result items to the client - it only sends a "page" worth - 30 or so.

    it maxes at 400. how many more bytes is 400 results vs 30? probably less than the PE zone spammers create every second :p

    many items don't even have 400 listings, or even 100. doing a new db req for such a simple thing the client can do in .00001 microseconds is beyond incompetent.
  • bioshrikebioshrike Member, NW M9 Playtest Posts: 4,729 Arc User
    edited December 2013
    What they should do is to *not* display any results until you select at least 1 category, and/or auto-default to items of your level, that are usable by you, sorted by lowest buy-out price...
    <::::::::::::::)xxxo <::::::::::::::)xxxo <::::::::::::)xxxxxxxx(:::::::::::> oxxx(::::::::::::::> oxxx(::::::::::::::>
    "Is it better to be feared or respected? I say, is it too much to ask for both?" -Tony Stark
    Official NW_Legit_Community Forums
  • kolbe11kolbe11 Member, Neverwinter Beta Users, Neverwinter Guardian Users Posts: 0 Arc User
    edited December 2013
    bioshrike wrote: »
    What they should do is to *not* display any results until you select at least 1 category, and/or auto-default to items of your level, that are usable by you, sorted by lowest buy-out price...

    While that alone would reduce the query rate on the database significantly, I think it should go even further:

    1) Disable "instant" queries whereby people type something in and click "search" as bioshrike suggested
    2) Disable "instant" query click results when simply expanding a tree
    3) Require a minimum number of characters... Similar to the forum's /10char

    As a IT geek who deals with Oracle/MS/MySQL/PostGRE DB's on a daily basis, I can clearly see the laziness being invoked by consumers when looking for items. Put simply: "You Can't Fix Stupid" and must take measure to at least reduce its effects.

    A SQL query goes into a bar, walks up between two tables and asks: "May I join you?"
    "It is said that idle hands are the Devil's tools: Idle geek hands, however, came up with gunpowder, nuclear weapons, and toilet plungers." -Illiad
  • bioshrikebioshrike Member, NW M9 Playtest Posts: 4,729 Arc User
    edited December 2013
    kolbe11 wrote: »
    While that alone would reduce the query rate on the database significantly, I think it should go even further:

    1) Disable "instant" queries whereby people type something in and click "search" as bioshrike suggested
    2) Disable "instant" query click results when simply expanding a tree
    3) Require a minimum number of characters... Similar to the forum's /10char

    As a IT geek who deals with Oracle/MS/MySQL/PostGRE DB's on a daily basis, I can clearly see the laziness being invoked by consumers when looking for items. Put simply: "You Can't Fix Stupid" and must take measure to at least reduce its effects.

    While they're at it, fix some items not coming up in their correct categories. For instance, HR blades are listed in the main hand category, and nothing comes up in the off-hand category. For TRs, off-hand-only daggers should be listed there, too.

    Also, set the results to be YOUR level only, unless the player specifically chooses higher or lower level items.

    Another - break profession lists into assets and resources. If an asset or resource can be used in 2 professions, it should be cross-listed in the results for both. For instance, anvils can be used for weaponsmithing, but only come up in platesmithing searches.

    Yet another issue - standardize namings - there are talismans that are wizard offhands, and there are neck items with 'talisman' in their names.
    <::::::::::::::)xxxo <::::::::::::::)xxxo <::::::::::::)xxxxxxxx(:::::::::::> oxxx(::::::::::::::> oxxx(::::::::::::::>
    "Is it better to be feared or respected? I say, is it too much to ask for both?" -Tony Stark
    Official NW_Legit_Community Forums
  • glanngalladglanngallad Member, Neverwinter Knight of the Feywild Users Posts: 26 Arc User
    edited December 2013
    Why do so many other MMOs get the AH right almost from the get-go? The Neverwinter AH has been broken forevvah....
  • froszztfroszzt Member, Neverwinter Beta Users Posts: 284 Bounty Hunter
    edited December 2013
    bioshrike wrote: »
    What they should do is to *not* display any results until you select at least 1 category, and/or auto-default to items of your level, that are usable by you, sorted by lowest buy-out price...

    Well. This. What else is there to say? Knowing cryptic we won't see any major overhaul to any mechanics in the game. But this should be easy enough. Why search before I have clicked a category? And why would it sort after the highest buyout, that is stupid as hell. Change these two small things and It will be less laggy, and even if it does nothing to the lag, it will still make it faster to search!
  • jintortlejintortle Member Posts: 655 Arc User
    edited December 2013
    My HR can not access AH at all except from main platform. So no in game or the guy in the market access at all. Very annoying.

    What I really want fixed up though is that when I look for something the Default is always the highest price. Then I have to click the price column twice to see the lowest because the Highest one just bloody refreshes.

    It is also basically impossible to even know what Armor or Weapon specific Enchantments are there unless you type in shard and then transfer one of the names there into the search tab and do a search to even see the properties. (Please I should not have to go to a web site offside to see what they are - so please do not give me suggestions - I know, I know)
    Genus Draco Fad and the Muster@Jintortle
    ID: NW-DD5FLOBTJ
    Cult of the Dragon Foundry Contest - Please participate and vote for your favourite - 26/6/2014 contest rating begins.

    Sir Camps A Lot. Mr SlingShot Boom. XX Phantasmagorical. Jinn Dragonfeast.
    SlingShot Boom Jr. Jocan Traders. Little Lord Forgatty, Dwarf Mean and introducing Necro Torquemada (The Warlock)
  • walk2kwalk2k Member Posts: 928 Arc User
    edited December 2013
    The auction broker is broken for HR.
  • chthonicmythoschthonicmythos Member, Moonstars, Neverwinter Beta Users, Neverwinter Hero Users, Neverwinter Guardian Users, Neverwinter Knight of the Feywild Users Posts: 0
    edited December 2013
    Please make this change cryptic and save your poor database! Besides waiting until you actually click "search" to do a search, I would like to see the first time you click on a sort option (buy now, time, etc) it sorts smallest to greatest. If I'm searching by buyout price, but then I want to search for time remaining I have to sort twice: first sorts from greatest to smallest, then I have to do it again the other way. Why so much extra load?
  • dndmasterdarkdndmasterdark Member Posts: 0 Arc User
    edited December 2013
    I give this post 2 thumbs up, consider it a valid request and the only answer I have to as why they would set it up the current way is...
    to nerf bots? Still tarded and also to be able to lock the buyout as a default to show the lowest price first should be an option!
    Engage! Another thing is... Why when I change characters do I still see his search info entered, should that not be cleared everytime I close the main AH window? :p
    I also agree this is creating unnecessary lag in AH and possibly server wide?
    Kinda feels like a cab ride where the driver takes off before you even close the door or tell him where to go...not to mention putting on your seatbelt!
  • runebanerunebane Member Posts: 0 Arc User
    edited December 2013
    eldarth wrote: »
    Submit search on Search Button, or Sort column ONLY.

    ^This. Very good idea. Would save on calls to the server. Not having to send info of every item in a category to the player.
    Halgarth's Legacy - NWS-DSTGFZHFR
  • rabbinicusrabbinicus Member Posts: 1,822 Arc User
    edited December 2013
    jintortle wrote: »
    My HR can not access AH at all except from main platform. So no in game or the guy in the market access at all. Very annoying.

    Same problem. I have reported it but have yet to see a response. :(
    The right to command is earned through duty, the privilege of rank is service.


  • adinosiiadinosii Member, NW M9 Playtest Posts: 4,294 Arc User
    edited December 2013
    And if the AH gets fixed at some point then please, please fix it at the same time so it sorts correctly, with the default being the cheapest object first - it is extremely irritating to always have to click "Sort" twice to see what you are really looking for.
    Hoping for improvements...
Sign In or Register to comment.