[DiscordArchive] Anyone ever thought about using ScyllaDB instead of slow-mo MySQL?
[DiscordArchive] Anyone ever thought about using ScyllaDB instead of slow-mo MySQL?
Original source
Anyone ever thought about using ScyllaDB instead of slow-mo MySQL?
rektbyfaith
06-09-2025, 04:15 PM #1Archived author: lucian_apetrei • Posted: 2025-06-09T16:15:14.664000+00:00
Original source
Anyone ever thought about using ScyllaDB instead of slow-mo MySQL?
Original source
single digit milisecond query time, off the shelf, no optimisation
rektbyfaith
06-09-2025, 04:15 PM #2Archived author: lucian_apetrei • Posted: 2025-06-09T16:15:36.231000+00:00
Original source
single digit milisecond query time, off the shelf, no optimisation
Original source
im using it for logging....for core itself i dont see any point u dont need that performance anywhere
rektbyfaith
06-09-2025, 04:34 PM #3Archived author: Rymercyble • Posted: 2025-06-09T16:34:13.633000+00:00
Original source
im using it for logging....for core itself i dont see any point u dont need that performance anywhere
Original source
Yeah I don't see much if any performance improvement from just switching the database used. You also have to consider what people know and use and there probably aren't many here who would be interested in making a switch like that.
rektbyfaith
06-09-2025, 04:43 PM #4Archived author: Revision • Posted: 2025-06-09T16:43:11.042000+00:00
Original source
Yeah I don't see much if any performance improvement from just switching the database used. You also have to consider what people know and use and there probably aren't many here who would be interested in making a switch like that.
Original source
It's probably a bit excessive but I clear out my entire build folder each time I install or uninstall a mod. It'll clean up any cmake issues
rektbyfaith
06-09-2025, 04:52 PM #5Archived author: JudgeFae • Posted: 2025-06-09T16:52:21.561000+00:00
Original source
It's probably a bit excessive but I clear out my entire build folder each time I install or uninstall a mod. It'll clean up any cmake issues
Original source
No problem, i wrote 1 by myself
rektbyfaith
06-09-2025, 04:52 PM #6Archived author: Wizz • Posted: 2025-06-09T16:52:55.427000+00:00
Original source
No problem, i wrote 1 by myself
Original source
now to be fair if we made it from scratch today we probably wouldnt use mysql more likely postgres or something
rektbyfaith
06-09-2025, 05:00 PM #7Archived author: Rymercyble • Posted: 2025-06-09T17:00:54.142000+00:00
Original source
now to be fair if we made it from scratch today we probably wouldnt use mysql more likely postgres or something
Original source
Yes but it wasn't written from scratch or recently at all and mysql is not the bottleneck in this situation. I mean it doesn't matter what you throw at it unless you fix everything that's going to be causing a bottleneck.
rektbyfaith
06-09-2025, 05:12 PM #8Archived author: Revision • Posted: 2025-06-09T17:12:11.909000+00:00
Original source
Yes but it wasn't written from scratch or recently at all and mysql is not the bottleneck in this situation. I mean it doesn't matter what you throw at it unless you fix everything that's going to be causing a bottleneck.
Original source
Just to make it clear, I'm not saying MySQL isn't bad. But as far as I can tell, with a limited knowledge of the emulator, it's more about how it's used rather than the choice of database itself. With playerbots, there have actually been people with a large amount of bots running (7000+) that had drives die because there's an insane amount of writes done at all times.
rektbyfaith
06-09-2025, 05:26 PM #9Archived author: Revision • Posted: 2025-06-09T17:26:47.075000+00:00
Original source
Just to make it clear, I'm not saying MySQL isn't bad. But as far as I can tell, with a limited knowledge of the emulator, it's more about how it's used rather than the choice of database itself. With playerbots, there have actually been people with a large amount of bots running (7000+) that had drives die because there's an insane amount of writes done at all times.
Original source
that doesnt sound realistic
rektbyfaith
06-09-2025, 05:29 PM #10Archived author: Rymercyble • Posted: 2025-06-09T17:29:37.461000+00:00
Original source
that doesnt sound realistic
1 Guest(s)
1 Guest(s)