[DiscordArchive] anyone having problems doing a fresh DB install?
[DiscordArchive] anyone having problems doing a fresh DB install?
Original source
can anyone try to run an empty world
rektbyfaith
01-15-2023, 07:40 PM #11Archived author: Linguster • Posted: 2023-01-15T19:40:55.475000+00:00
Original source
can anyone try to run an empty world
Original source
Sure I'll give it a go
rektbyfaith
01-15-2023, 07:41 PM #12Archived author: Bench • Posted: 2023-01-15T19:41:33.394000+00:00
Original source
Sure I'll give it a go
Original source
That's my fishing pool PR
rektbyfaith
01-15-2023, 07:42 PM #13Archived author: Gultask • Posted: 2023-01-15T19:42:36.210000+00:00
Original source
That's my fishing pool PR
Original source
It happened before that it takes forever
rektbyfaith
01-15-2023, 07:42 PM #14Archived author: Gultask • Posted: 2023-01-15T19:42:42.183000+00:00
Original source
It happened before that it takes forever
Original source
Can't imagine why, though
rektbyfaith
01-15-2023, 07:42 PM #15Archived author: Gultask • Posted: 2023-01-15T19:42:48.677000+00:00
Original source
Can't imagine why, though
Original source
oh, it went through
rektbyfaith
01-15-2023, 07:43 PM #16Archived author: Linguster • Posted: 2023-01-15T19:43:45.048000+00:00
Original source
oh, it went through
Original source
<@203326888888893440>
rektbyfaith
01-15-2023, 07:43 PM #17Archived author: Linguster • Posted: 2023-01-15T19:43:49.439000+00:00
Original source
<@203326888888893440>
Original source
Okey dokey
rektbyfaith
01-15-2023, 07:43 PM #18Archived author: Bench • Posted: 2023-01-15T19:43:54.047000+00:00
Original source
Okey dokey
Original source
/* Affected rows: 2.430 Found rows: 0 Warnings: 0 Duration for 16 queries: 7,469 sec. */
rektbyfaith
01-15-2023, 07:44 PM #19Archived author: Gultask • Posted: 2023-01-15T19:44:08.849000+00:00
Original source
/* Affected rows: 2.430 Found rows: 0 Warnings: 0 Duration for 16 queries: 7,469 sec. */
Original source
```
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));
```
This query takes the longest. It's 2 nested selects. I'll keep it in mind for the future.
rektbyfaith
01-15-2023, 07:44 PM #20Archived author: Gultask • Posted: 2023-01-15T19:44:54.865000+00:00
Original source
```
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));
```
This query takes the longest. It's 2 nested selects. I'll keep it in mind for the future.