[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
Archived author: vblanco • Posted: 2022-06-20T18:47:13.294000+00:00
Original source
plus in my tests with sqlite for game use (singleplayer tho) its super super fast
Archived author: <o> • Posted: 2022-06-20T18:48:15.182000+00:00
Original source
many servers need to communicate with the database from both the game itself and their websites etc
Archived author: vblanco • Posted: 2022-06-20T18:48:37.534000+00:00
Original source
yeh thats really the more problematic point. Sqlite is more about local-use db than remote-use
Archived author: <o> • Posted: 2022-06-20T18:49:21.238000+00:00
Original source
it's not impossible by any means, but a lot of the database subproject is very hard written for mysql and it'd be a considerable challenge to rewrite all that while making sure you're not introducing regressions
Archived author: <o> • Posted: 2022-06-20T18:49:41.762000+00:00
Original source
the last point is the key, really
Archived author: vblanco • Posted: 2022-06-20T18:49:53.362000+00:00
Original source
ye. and the fact that mysql code does not directly run on sqlite
Archived author: vblanco • Posted: 2022-06-20T18:49:58.992000+00:00
Original source
couse its different dbs after all