Development Cycle Archive
Thread: Schematics limited to 100
A database reply to the schematic issue
table storing data on resources and serial numbers
1 record holds a particular serial number with its stats and everything for each resource per charcter per container
1 record for the schematic wether 100 or 1000
this does not impact in any way shape or form the database resources required to store your resource information you will still need to collect resources based on your usage
This does not impact your final runs in any way since if you are going to create 1000 final products your still going to create them but now you may need More records to store the various schematics but the same number of factory crates will still be crated or less but the volume of database resources used will not be decreased you created 20 crates before you will still create 20 crates and have to have 20 records in the database but you will need a additional 10 records for your datapad... this will be tricky with some proffesions that already cant store all there base schematics or are close to the cap so now droids are needed again more records made and stored.
why in a game made to support millions of records IE things in game on servers that are not up to capacity and only 3 months into release are there database utilization issues???
why am i even posting since this wont even mater at 23 pages of replies.
dv
Narae wrote:and having 18 schematics (100) all with different serial numbers, for every crafter, every day, isnt worse for the database?
-Nyka
I think it is worse than that.
I am skeptical as a software engineer that the schematic count has any bearing on load.
I fault Holo for speculating that this is a DB issue in starting this thread and trying to equate schematic max counts to item storage or other issues that do effect the database. I understand, it is safe for him to speculate and in his position he really does not have much insight into specific implementation issues. No reason he should, he is a much higher level designer and not a code monkey on this project. However he should have stopped and thought for a minute about it. 100 or 1000 schematic count only affects player convenience and has no effect on the database or the total number of items in the game.
1) The number of total items created will continue to increase as a function of the number of players and the max storage capacity. Players will simply make 10 schematics where before they made 1. Powergamers will have no problem with this change and will simply borrow more lots for more factories to make up for the inconvenience. If there is demand there will be people who meet that demand regardless of the inconvenience. Who supplies most goods might change, but the total amount will continue to increase over time as long as more people enter the game.
2) The database load from factory visits will go up. Factories do not load the system while they are running, they are not even in memory while they are running (harvesters either). The only time they put a load on the system is when you visit them. That means that in order to meet demand players will have to visit their factories up to 10 times as much resulting in up to 10 times the load on the system for factory visits. There will also be more factories to compensate for the decrease in max schematic size further increasing load.
3) Schematic count is not equal to amount of items created. Many players, myself included will run 200-500 at a go based on resources and the item being created. What the 1000 gives us is flexibility and convenience and in some cases (structural modules) is just about right.
Since the count of the schematic does not effect load and only convenience I say leave it at 1000 and fix the real bug, the slider.
If the devs really want to reduce some storage issues then here is a tip. Increase the max count on many factory crates, especially consumables like powerups. They are currently at 10, make them 25 at least, that is a 2.5 reduction in the number of factory objects stored.
If there's a database issue with larger schems...then why isn't theDB crashing now with everyone running 1000 schems?
If it's working fine as is, why jack with it just because "it's a bug"????
LET IT ALONE HOLO AND GO WORK ON SOMETHING IMPORTANT.
This is a good thing!!
This probably won't even get read but I'm throwing in my 2 cents anyway.
Eliminating the 1000 would be a huge blow to crafters in general, but especially to people who make powerups. Some of you may not know, but the type of powerup you create is completely random, so after standing by your crafting machine making 10s to 100s of them by hand, you may or may not actually make one worth making into a schematic. So now you're saying after I waste all this time trying to come up with a powerup that people want, i can only make 10 crates of them? Welcome to triple priced powerups, no way am I wasting an hour of my life making something worth less than the guns i can sell just as many of for 100 times the amount.
Also in the case of weapon parts, so now i'll have 10-20 schematics for powerhandlers or barrels, 1 for each gun, instead of 1 schematic for 1000. So obviously this isn't something to do with creating space for the database, nice try though.
Please explain why you're trying to kick crafters around.
And while we're on that topic, i read the TC patch notes. Nothing at all about any changes for weaponsmiths. We've been complaining for MONTHS about buggy parts, especially feed mechs, projectile barrels and chem nozzles(which you still currently cannot experiment on). When is this stuff going to be looked at and fixed? And why do you have it out for those of us who do the server as a whole a great service in a terribly monotonous job. Without smiths, you have no players, because no one can use a cdef to fight higher lvl stuff. So stock kicking us down the ladder and help us out.
100 item limit on schematics = BAD idea.
I'm a Master Architect. I go through hundreds of structural modules in the course of building installations and harvesters. A PA Hall takes 15-17 walls at 10 structural modules per wall. So now every 9 Walls I will have to waste the material to make a new schematic, then babysit my factory? I make my structure module schematics at 1000 counts and I use the whole thing.
Newsflash: I ALREADY HAVE TO WASTE HALF MY GAME TIME BABYSITTING MY FACTORY! If you could just frickin' fix it so that factories can pull from Crates, I wouldn't need to spend 2 hours standing in front of my factory hand feeding it structure modules to make walls! **edit** is up with that?
Now, adding insult to injury, you are going to make it so I can basically only make 9 walls before going back to waste a full wall's worth of material to make 9 more walls?
Please rethink where you are going with crafting in this game. I have friends leaving almost daily because of your changes to the game; only coming back to see if the game is any more "fun". I remain only because of my guild.
Un-fork yourselves, and quickly. "Database limitations" my furry Wookiee butt.
Powerups are the only thing that will be a problem for me if schematic uses are limited to 100. It can take hours of crafting to get the type of powerup that is most popular and the best seller and 100 uses really isn't enough considering that investment of time.
If uses are limited to 100, then powerups should be changed to make it easier to get the type we want. Perhaps the speed, minimum and maximum damage types could be made more common with higher experimentation bonuses, or higher complexity powerups (capacitors, clips, etc.) with a better options limited to those prefered types be added to the game.
Eshren Jandl, Sunrunner
first off i think if i'd have to make a new schematic every 100 armor segments, i just as soon recover my skill points and join the masses as a CH, BH ,Pistoleer, Medic or commando, medic, CH if i don't just move on.
what i don't get is, if an insignificant little zero on the right cancauses so much trouble on the database, then what will the 9 diffrent runsworth of leftover segments replacing the single 1000 count run in small batchesdo to it' not to mention the thousands of bad prototypes produced from the schematic creation prossesin terms of server load and data volume.
If it is in fact a database issue, why not split the load on the the database clusters by running less galaxies off each cluster,ohh say 4 instead of 8, sure it'll cost a little more, but without going into financial speculation i can safely say that SGW if more than profitable enought to support 3 or even 5 new DB clusters and at the same time you could finaly give us some realistic storage space as it is now i have over 100 diffrent stacks of resources in the bank as well as a 3 factories and a medium house full to capacity and95% of it isarmor crafting related items material and components, loot from quests isn't worth keeping so thats not a problem. hell i can't even buy new cloths because i have no place to store them.
Simple solution that remedies all....
Limit the runs to 100. But make the schematics, once loaded into the factory, reusable. Once loaded , you can crank out 10,000 of the item if thats all that factory runs. But it is only 100 units at a time, and then you have to clear the output hopper and restart it.
Now for a doctor, it woudl be great to have a factory in place for each component and never change it out. but who has the lots available for that? No one. And you cant gurantee you woudl get the exact same resources. So these in themselves would be limiting factors. But if you DID have 32K of those rare components, you COULD continually run it and get 1000 advanced components done.
.... 100 at a time....
...off the identical schematic....
Umm. That doesn't remedy all. My main problem isn't remaking the schematics, it's having to go check on my factories all the time. If runs are limited to 100, that has the same effect as schematics being limited to 100 for me. I don't want to be chained to a factory!
I am absolutely in Horrified.
Firstly, I am a doctor - maker of meds, etc.
Its been said a lot in these pages, but Stim Es, will produce 33 attempts, some of which will be consumed in the attempt to make the schematic. Currently, I make 333 items with that schematic. That requires a 1000 run of Biological Effects controller. This produced 6 finished goods for me to sell!!! 6 Crates of 50. It takes a full day of crafting to produce 6 items. SIX!!!!
If this goes live I will not be able to produce ONE!
Now some people have suggested that we be able to make components in larger runs, I urge you not to do this either, leave everything at 1000. With component runs at 1000 and item runs at 100 I will be making only TWO(2) items at a time. That's just not fair, when another profession can make 100 finished items at a time.
Absolutely Horrified.
I will not claim that I will quit the game over this. I will without a shadow of a doubt stop crafting medical supplies for sale if this goes live.