[DiscordArchive] what if u fixed sql scripts instead ?
[DiscordArchive] what if u fixed sql scripts instead ?
Archived author: Revision • Posted: 2024-01-07T02:48:37.995000+00:00
Original source
I'm not judging it, I'm just saying what happened
Archived author: Kitzunu • Posted: 2024-01-07T02:48:45.759000+00:00
Original source
Yea I know
Archived author: Rymercyble • Posted: 2024-01-07T02:48:48.282000+00:00
Original source
I mean if some1 rly wanted to have performance and compatibility there would be joins not sub selects and that would just work but I admit often it's simpler to write sub select
Archived author: Kitzunu • Posted: 2024-01-07T02:49:08.251000+00:00
Original source
Just emphasizing it for people who dont knwo
Archived author: Revision • Posted: 2024-01-07T02:49:28.879000+00:00
Original source
Just like I said back then, if it bothers me that performance is degraded for mariadb then I can just run a separate server for mysql to deal with it. It's up to me and that's what I did.
Archived author: Revision • Posted: 2024-01-07T02:49:58.564000+00:00
Original source
That's true for everyone though, of course.
Archived author: Rymercyble • Posted: 2024-01-07T02:50:08.407000+00:00
Original source
It shouldn't be too hard to rewrite all sub selects to joins though
Archived author: Kitzunu • Posted: 2024-01-07T02:50:08.649000+00:00
Original source
Yeye
Archived author: Kitzunu • Posted: 2024-01-07T02:50:28.445000+00:00
Original source
Squash the db and there are no more queries
Archived author: Kitzunu • Posted: 2024-01-07T02:50:29.572000+00:00
Original source
Pog