[DiscordArchive] why would it take so much longer ? its just bunch of selects with joins right ?
[DiscordArchive] why would it take so much longer ? its just bunch of selects with joins right ?
Archived author: Rymercyble • Posted: 2023-04-26T19:51:53.998000+00:00
Original source
why would it take so much longer ? its just bunch of selects with joins right ?
Archived author: Revision • Posted: 2023-04-26T19:56:04.076000+00:00
Original source
For some reason it's this specific query it hangs on (at least at first): https://github.com/azerothcore/azerothco....cpp#L2143
Archived author: Revision • Posted: 2023-04-26T19:56:27.236000+00:00
Original source
I was using MariaDB 10.6 (default one with Ubuntu 22.04) so it's not like it's an old version.
Archived author: Rymercyble • Posted: 2023-04-26T19:57:47.260000+00:00
Original source
maybe u can try running it through sql client
Archived author: Revision • Posted: 2023-04-26T19:58:09.385000+00:00
Original source
I did
Archived author: Rymercyble • Posted: 2023-04-26T20:01:00.572000+00:00
Original source
and i assume it finished in 10ms right
Archived author: Revision • Posted: 2023-04-26T20:01:24.195000+00:00
Original source
It never did. Well, I gave up after literally 2 minutes.
Archived author: Rymercyble • Posted: 2023-04-26T20:01:41.352000+00:00
Original source
i mean when running by itself in sql client
Archived author: Revision • Posted: 2023-04-26T20:04:26.406000+00:00
Original source
Yes, I did that too. Again, I gave up after a long time of it running the query.
Archived author: Rymercyble • Posted: 2023-04-26T20:04:40.546000+00:00
Original source
https://tenor.com/view/hmm-dot-dot-dot-s...f-23376515