[DiscordArchive] I mean does the client load the entire table data in the ram? what did you mean by loaded on startup
[DiscordArchive] I mean does the client load the entire table data in the ram? what did you mean by loaded on startup
Original source
I mean does the client load the entire table data in the ram? what did you mean by loaded on startup and never again?
rektbyfaith
06-11-2025, 11:07 AM #1Archived author: lucian_apetrei • Posted: 2025-06-11T11:07:50.599000+00:00
Original source
I mean does the client load the entire table data in the ram? what did you mean by loaded on startup and never again?
Original source
Cause I didn't get that.
rektbyfaith
06-11-2025, 11:08 AM #2Archived author: lucian_apetrei • Posted: 2025-06-11T11:08:07.610000+00:00
Original source
Cause I didn't get that.
Original source
server loads most of data on startup
rektbyfaith
06-11-2025, 11:08 AM #3Archived author: Rymercyble • Posted: 2025-06-11T11:08:35.676000+00:00
Original source
server loads most of data on startup
Original source
Was aiming to reply to <@251803844307189761>
rektbyfaith
06-11-2025, 11:08 AM #4Archived author: lucian_apetrei • Posted: 2025-06-11T11:08:39.241000+00:00
Original source
Was aiming to reply to <@251803844307189761>
Original source
i didnt check if all tables and entire tables so cant say for sure but generally yes it just loads it and never again
rektbyfaith
06-11-2025, 11:09 AM #5Archived author: Rymercyble • Posted: 2025-06-11T11:09:16.973000+00:00
Original source
i didnt check if all tables and entire tables so cant say for sure but generally yes it just loads it and never again
Original source
So I guess to both of you then., does the server load the table data in ram, what do you mean by that? can give more details? do you mean that mysql indexes the data, what did you mean?
rektbyfaith
06-11-2025, 11:09 AM #6Archived author: lucian_apetrei • Posted: 2025-06-11T11:09:53.916000+00:00
Original source
So I guess to both of you then., does the server load the table data in ram, what do you mean by that? can give more details? do you mean that mysql indexes the data, what did you mean?
Original source
mysql is just storage...server starts queries DB for all its data and keeps it in it (in server process so in ram)
rektbyfaith
06-11-2025, 11:11 AM #7Archived author: Rymercyble • Posted: 2025-06-11T11:11:06.745000+00:00
Original source
mysql is just storage...server starts queries DB for all its data and keeps it in it (in server process so in ram)
Original source
yes I know how it works, but I still don't get what am I supposed to learn here? What am I missing?
ScyllaDB works in a similar way to mysql, it's not a relational database, but they all work with the RAM, so I don't understand why that was brought up.
My point is this, for a query that mysql can finish let's say in 1s, 500ms or even 100ms, scylla can do it in 10ms or less, multiply this with number of players and you improve efficiency by orders of magnitude.
rektbyfaith
06-11-2025, 11:13 AM #8Archived author: lucian_apetrei • Posted: 2025-06-11T11:13:33.126000+00:00
Original source
yes I know how it works, but I still don't get what am I supposed to learn here? What am I missing?
ScyllaDB works in a similar way to mysql, it's not a relational database, but they all work with the RAM, so I don't understand why that was brought up.
My point is this, for a query that mysql can finish let's say in 1s, 500ms or even 100ms, scylla can do it in 10ms or less, multiply this with number of players and you improve efficiency by orders of magnitude.
Original source
but that will mean absolutely nothing when queries are executed only once
rektbyfaith
06-11-2025, 11:14 AM #9Archived author: Rymercyble • Posted: 2025-06-11T11:14:00.415000+00:00
Original source
but that will mean absolutely nothing when queries are executed only once
1 Guest(s)
1 Guest(s)