[DiscordArchive] squishy squashy no more slow query?
[DiscordArchive] squishy squashy no more slow query?
Original source
squishy squashy no more slow query?
rektbyfaith
03-04-2023, 11:16 PM #1Archived author: Anchy • Posted: 2023-03-04T23:16:22.160000+00:00
Original source
squishy squashy no more slow query?
Original source
```sql
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (182954, 182953, 182952, 182957, 182954, 182956, 182951, 182959, 182958) AND `map`=530));
DELETE FROM `pool_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (182954, 182953, 182952, 182957, 182954, 182956, 182951, 182959, 182958) AND `map`=530);
```
rektbyfaith
03-04-2023, 11:16 PM #2Archived author: Kitzunu • Posted: 2023-03-04T23:16:23.673000+00:00
Original source
```sql
DELETE FROM `pool_template` WHERE `entry` IN (SELECT `pool_entry` FROM `pool_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (182954, 182953, 182952, 182957, 182954, 182956, 182951, 182959, 182958) AND `map`=530));
DELETE FROM `pool_gameobject` WHERE `guid` IN (SELECT `guid` FROM `gameobject` WHERE `id` IN (182954, 182953, 182952, 182957, 182954, 182956, 182951, 182959, 182958) AND `map`=530);
```
Original source
https://github.com/azerothcore/azerothco..._03_07.sql
rektbyfaith
03-04-2023, 11:16 PM #3Archived author: Kitzunu • Posted: 2023-03-04T23:16:28.071000+00:00
Original source
https://github.com/azerothcore/azerothco..._03_07.sql
Original source
I'm not going to explain that there are issues with nested queries when using MairaDB. I'm not going to update it to melt some brains.
rektbyfaith
03-04-2023, 11:16 PM #4Archived author: Revision • Posted: 2023-03-04T23:16:33.972000+00:00
Original source
I'm not going to explain that there are issues with nested queries when using MairaDB. I'm not going to update it to melt some brains.
Original source
if you cant run that in Maria. then why support it <:kek:1065379143887372398>
rektbyfaith
03-04-2023, 11:16 PM #5Archived author: Kitzunu • Posted: 2023-03-04T23:16:52.369000+00:00
Original source
if you cant run that in Maria. then why support it <:kek:1065379143887372398>
Original source
That update takes up to 5 minutes on slow MariaDB servers, for the record.
rektbyfaith
03-04-2023, 11:16 PM #6Archived author: Revision • Posted: 2023-03-04T23:16:55.907000+00:00
Original source
That update takes up to 5 minutes on slow MariaDB servers, for the record.
Original source
Then it’ll be poor documentation.
rektbyfaith
03-04-2023, 11:17 PM #7Archived author: Michael Crilly • Posted: 2023-03-04T23:17:00.418000+00:00
Original source
Then it’ll be poor documentation.
Original source
you can run it, it just takes until the heat death of the universe to finish <:kek:1065379143887372398>
rektbyfaith
03-04-2023, 11:17 PM #8Archived author: Anchy • Posted: 2023-03-04T23:17:22.818000+00:00
Original source
you can run it, it just takes until the heat death of the universe to finish <:kek:1065379143887372398>
Original source
If someone asks you to fix their computer you're not going to explain exactly how a computer works, you just say that it's an issue with firewall/driver/etc and fix it.
rektbyfaith
03-04-2023, 11:17 PM #9Archived author: Revision • Posted: 2023-03-04T23:17:40.121000+00:00
Original source
If someone asks you to fix their computer you're not going to explain exactly how a computer works, you just say that it's an issue with firewall/driver/etc and fix it.
Original source
Or even just.. fix it
rektbyfaith
03-04-2023, 11:17 PM #10Archived author: Revision • Posted: 2023-03-04T23:17:56.762000+00:00
Original source
Or even just.. fix it