[DiscordArchive] Performance wise though what's the benefit of having a table of more "complex" flags over a single a
[DiscordArchive] Performance wise though what's the benefit of having a table of more "complex" flags over a single a
Original source
they might have, we have a more db row-oriented system for dynamic items in tswow now that tester wrote
rektbyfaith
06-20-2022, 06:32 PM #21Archived author: <o> • Posted: 2022-06-20T18:32:22.915000+00:00
Original source
they might have, we have a more db row-oriented system for dynamic items in tswow now that tester wrote
Original source
but it has the drawbacks vblanco mentioned, if you rely too much on those kinds of dynamic items your db never stops growing
rektbyfaith
06-20-2022, 06:32 PM #22Archived author: <o> • Posted: 2022-06-20T18:32:45.450000+00:00
Original source
but it has the drawbacks vblanco mentioned, if you rely too much on those kinds of dynamic items your db never stops growing
Original source
Isn't this solved in WoW by a lack of "dynamic" item storage with a theoretical hard cap per player/account?
rektbyfaith
06-20-2022, 06:33 PM #23Archived author: whatwere • Posted: 2022-06-20T18:33:16.038000+00:00
Original source
Isn't this solved in WoW by a lack of "dynamic" item storage with a theoretical hard cap per player/account?
Original source
If you have a million different players that's a maximum of around 200ish items
rektbyfaith
06-20-2022, 06:33 PM #24Archived author: whatwere • Posted: 2022-06-20T18:33:50.378000+00:00
Original source
If you have a million different players that's a maximum of around 200ish items
Original source
somewhat, but item templates are really big by default, and if each player can hold hundreds of them you'll run into some real storage problem at some point
rektbyfaith
06-20-2022, 06:34 PM #25Archived author: <o> • Posted: 2022-06-20T18:34:03.202000+00:00
Original source
somewhat, but item templates are really big by default, and if each player can hold hundreds of them you'll run into some real storage problem at some point
Original source
of course you can create smart solutions to solve that, but that's not the system we have currently
rektbyfaith
06-20-2022, 06:34 PM #26Archived author: <o> • Posted: 2022-06-20T18:34:34.724000+00:00
Original source
of course you can create smart solutions to solve that, but that's not the system we have currently
Original source
I guess nested Jewelcrafting is probably not the smart solution
rektbyfaith
06-20-2022, 06:35 PM #27Archived author: whatwere • Posted: 2022-06-20T18:35:20.673000+00:00
Original source
I guess nested Jewelcrafting is probably not the smart solution
Original source
Where each jewel holds more jewels and the stats of the item are the sum of all of them recursively
rektbyfaith
06-20-2022, 06:35 PM #28Archived author: whatwere • Posted: 2022-06-20T18:35:41.705000+00:00
Original source
Where each jewel holds more jewels and the stats of the item are the sum of all of them recursively
Original source
Had that idea at some point, luckily it never got anywhere
rektbyfaith
06-20-2022, 06:36 PM #29Archived author: whatwere • Posted: 2022-06-20T18:36:09.031000+00:00
Original source
Had that idea at some point, luckily it never got anywhere
Original source
not if that recursion grows infinitely since you can then have unlimited amounts of items, but that'd be more a system for its own sake than solving anything storage or performance
rektbyfaith
06-20-2022, 06:36 PM #30Archived author: <o> • Posted: 2022-06-20T18:36:43.961000+00:00
Original source
not if that recursion grows infinitely since you can then have unlimited amounts of items, but that'd be more a system for its own sake than solving anything storage or performance
1 Guest(s)
1 Guest(s)