[DiscordArchive] if you could do it either way, what would perform better with Eluna? running a sql query and selecti
[DiscordArchive] if you could do it either way, what would perform better with Eluna? running a sql query and selecti
Original source
if you could do it either way, what would perform better with Eluna? running a sql query and selecting the values or keeping the values in a lua table and calling them?
rektbyfaith
08-03-2021, 07:50 PM #1Archived author: gigi • Posted: 2021-08-03T19:50:20.073000+00:00
Original source
if you could do it either way, what would perform better with Eluna? running a sql query and selecting the values or keeping the values in a lua table and calling them?
Original source
lua table
rektbyfaith
08-03-2021, 07:51 PM #2Archived author: tester • Posted: 2021-08-03T19:51:02.424000+00:00
Original source
lua table
Original source
normally sql table is good that you can basically only have to query the db once on startup or on some interval, pull all data, push it into the cache table
rektbyfaith
08-03-2021, 07:51 PM #3Archived author: tester • Posted: 2021-08-03T19:51:30.924000+00:00
Original source
normally sql table is good that you can basically only have to query the db once on startup or on some interval, pull all data, push it into the cache table
Original source
then the script uses the table
rektbyfaith
08-03-2021, 07:51 PM #4Archived author: tester • Posted: 2021-08-03T19:51:35.687000+00:00
Original source
then the script uses the table
Original source
If you have enough data then there comes a point where it is more better to query the data you need and maybe cache some of it rather than caching it all in a single table, but that would need to be a lot of data
rektbyfaith
08-03-2021, 07:52 PM #5Archived author: stoneharry • Posted: 2021-08-03T19:52:32.478000+00:00
Original source
If you have enough data then there comes a point where it is more better to query the data you need and maybe cache some of it rather than caching it all in a single table, but that would need to be a lot of data
Original source
alright, thanks!
rektbyfaith
08-03-2021, 07:52 PM #6Archived author: gigi • Posted: 2021-08-03T19:52:54.555000+00:00
Original source
alright, thanks!
Original source
fair, but at a point if too much data, its still normally more performant to have multiple cache tables rather than database queries
rektbyfaith
08-03-2021, 07:53 PM #7Archived author: tester • Posted: 2021-08-03T19:53:11.935000+00:00
Original source
fair, but at a point if too much data, its still normally more performant to have multiple cache tables rather than database queries
Original source
suppose it would matter on some usecases though
rektbyfaith
08-03-2021, 07:53 PM #8Archived author: tester • Posted: 2021-08-03T19:53:38.405000+00:00
Original source
suppose it would matter on some usecases though
Original source
There's never one right answer when it comes to performance
rektbyfaith
08-03-2021, 07:54 PM #9Archived author: stoneharry • Posted: 2021-08-03T19:54:30.106000+00:00
Original source
There's never one right answer when it comes to performance
1 Guest(s)
1 Guest(s)