Development Cycle Archive
Thread: In-Test: Merchant Vendor Changes
Numen
Mon Aug 16, 2004 3:22 pm
#27
Rubicon49BC wrote:
Simple database logic.
If you have 1 vendor with 3000 items, each time someone accesses the vendor, all 3000 items must be loaded, leading to strain on database. With 250 limit per vendor, database strain is much lower. Strain is not just in how much is in database, but how much must be loaded in each time.
Your missing a small piece of info for proof. All 3000 items don't get loaded at once. Only a max of 100 items on a player vendor are loaded at the same time(at least that should be what happens). When I hit next items, there is a delay. That delay should be the delay to get the info from the database.
One suggestion.
For merchants, we can view all our items over all our vendors at once. Would it be possible to get that same feature for customers? So instead of having 12 vendors in the front room. You could have 1 or 2 and then 10-11 in the back room. 12 vendors per merchant is going to be a nightmare in malls.
Mejowepra
Mon Aug 16, 2004 3:23 pm
#28
Short comment: Looks great. Limits are high enough for me. 12 vendors is great. Also due to the 250 limit even at novice, you don't need to invest all your points to run an average sized business which is great.
Again, this works for me, no complaints. An aggregate max would be nice but with 250 per vendor, it is good enough. we'll see have a use for the 'next page' button.
Again, this works for me, no complaints. An aggregate max would be nice but with 250 per vendor, it is good enough. we'll see have a use for the 'next page' button.
Elyssa
Mon Aug 16, 2004 3:23 pm
#29
While these limits aren't as high as I would have liked, I do understand the need for item limits.
My biggest concern was not having enough space to sell all the items I could produce in a quantity that would relieve the pain of constant restocking.
A 250 item limit would absolutely strangle me under the current system because I would need all 6 of my vendors just to sell furniture.
However, 12 vendors presents a feasable solution by allowing me to categorize my furniture amongst different vendors.
Since some of my vendors rarely have in excess of 100 items, I will not be forced to cram 15 different product lines onto a single vendor either.
I declare this solution to be acceptable.
Nice work.
Now, let's revamp that vendor interface and give us a "restock as listed" button and make it easier to do consignment sales!
Oh, and don't think we haven't forgotten about the recursive macro thing either. 
Draconis666
Mon Aug 16, 2004 3:24 pm
#30
I like it. I was worried about it so much from the previously listed limits that I started going for Master Merchant as quick as I could. At least now I can slow down... nah, I'll keep it up just to get master sooner. 
Moepple
Mon Aug 16, 2004 3:26 pm
#31
EnFERn0 wrote:
Why is the limit on Vendors and no on Master Merchant?
Many vendors only creates mess and lag when loading
Because Merchants need diversity. And its easier to have a limit thats hardcoded to the vendor instead of each time you access a vendor testing it against your skill. The more things you check, the larger the lag will be.
As a Merchant, and one of those who suggested more vendors since Months, this part of the Solution is great, however, I still would prefer a 600 Items per Vendor limit.
Message Edited by Moepple on 08-16-2004 03:28 PM
Rubicon49BC
Mon Aug 16, 2004 3:28 pm
#32
Numen wrote:
Rubicon49BC wrote:
Simple database logic.
If you have 1 vendor with 3000 items, each time someone accesses the vendor, all 3000 items must be loaded, leading to strain on database. With 250 limit per vendor, database strain is much lower. Strain is not just in how much is in database, but how much must be loaded in each time.Your missing a small piece of info for proof. All 3000 items don't get loaded at once. Only a max of 100 items on a player vendor are loaded at the same time(at least that should be what happens). When I hit next items, there is a delay. That delay should be the delay to get the info from the database.One suggestion.For merchants, we can view all our items over all our vendors at once. Would it be possible to get that same feature for customers? So instead of having 12 vendors in the front room. You could have 1 or 2 and then 10-11 in the back room. 12 vendors per merchant is going to be a nightmare in malls.
I don't think it entirely works that way ingame. They could have designed it that way, but I think they load in all info directly as it stands. I could probably test that more extensively though on a high and low-item vendor and see if there is a difference in loadtimes.
akamai_keniki
Mon Aug 16, 2004 3:29 pm
#33
Awesome....glad to see they listened to the outcry of so many as to the original numbers proposed.
Someday maybe we can even make the interface a little easier to use for stocking vendors and relisting items that don't sell....but for now, this is a great start
Mkappus
Mon Aug 16, 2004 3:29 pm
#34
TH, congrats, I think this may be the first time someone has actually delivered a solution on the date promised. I don't mean to be overly sarcastic, but more to congratulate you on delivering information on the day you promised. I know lots of people have stopped crafting waiting to hear what was going to happen. I now can start making furniture again.
speardancer
Mon Aug 16, 2004 3:29 pm
#35
It's a move in the right direction, but I withhold praise until I figure some things out at home tonite...
and can you give us more of a box-by-box breakout of the skills? although I think I can sort it out, I'd rather not make assumptions...
and can you give us more of a box-by-box breakout of the skills? although I think I can sort it out, I'd rather not make assumptions...
sliceryoung
Mon Aug 16, 2004 3:30 pm
#36
this is a very nice compromise. i do feel the wording may confuse some people into believing they onl;y need merchant 0/0/0/4 to have 10 vendors. and i too think we need some new looks for our merchants, have you noticed that 9/10 vendors created are obese 
Xispin
Mon Aug 16, 2004 3:30 pm
#37
what happens to vendors that stayed even though the person dropped merchant?
CapricornONE
Mon Aug 16, 2004 3:31 pm
#38
this is, in one word: Awesome!!!
i usually keep about 100-200 items on my vendors (perfect)
and not only this but I get an aditional vendor!
This rocks! thanx TH
Algjp
Mon Aug 16, 2004 3:32 pm
#39
Rubicon49BC wrote:
Simple database logic.
If you have 1 vendor with 3000 items, each time someone accesses the vendor, all 3000 items must be loaded, leading to strain on database. With 250 limit per vendor, database strain is much lower. Strain is not just in how much is in database, but how much must be loaded in each time.
Yeah but they only load 100 per page anyway.