[DiscordArchive] How can I know an exact rate limit value? Is it SQL bottleneck or is there some handler in AC which
[DiscordArchive] How can I know an exact rate limit value? Is it SQL bottleneck or is there some handler in AC which
Original source
Try disabling warden temporarily
rektbyfaith
11-13-2023, 04:34 PM #11Archived author: Revision • Posted: 2023-11-13T16:34:06.289000+00:00
Original source
Try disabling warden temporarily
Original source
Warden or just something related to packet spam.
rektbyfaith
11-13-2023, 04:34 PM #12Archived author: Honey • Posted: 2023-11-13T16:34:28.298000+00:00
Original source
Warden or just something related to packet spam.
Original source
as was said depends on setup but u wont rly get 50k inserts out of default mysql installation....50k rows in 50 queries 1000 rows per query ? sure thats not that hard but 50k queries have such overhead that its not so simple
rektbyfaith
11-13-2023, 04:38 PM #13Archived author: Rymercyble • Posted: 2023-11-13T16:38:30.204000+00:00
Original source
as was said depends on setup but u wont rly get 50k inserts out of default mysql installation....50k rows in 50 queries 1000 rows per query ? sure thats not that hard but 50k queries have such overhead that its not so simple
Original source
The more threads, the more you can get out of it.
rektbyfaith
11-13-2023, 04:39 PM #14Archived author: Revision • Posted: 2023-11-13T16:39:58.683000+00:00
Original source
The more threads, the more you can get out of it.
Original source
Hey so did anyone notice that as a hunter, if you aggro a mob that is a higher level than yourself and *then* after you have aggro'd it already, manually let your pet use growl and that growl then *fails*, that your pet is now stuck in place and refuses to move
rektbyfaith
11-13-2023, 04:40 PM #15Archived author: DrNefarius • Posted: 2023-11-13T16:40:19.165000+00:00
Original source
Hey so did anyone notice that as a hunter, if you aggro a mob that is a higher level than yourself and *then* after you have aggro'd it already, manually let your pet use growl and that growl then *fails*, that your pet is now stuck in place and refuses to move
Original source
you can bypass that ingame by clicking on follow and then attack again, so it starts moving, but it's still weird
rektbyfaith
11-13-2023, 04:41 PM #16Archived author: DrNefarius • Posted: 2023-11-13T16:41:13.761000+00:00
Original source
you can bypass that ingame by clicking on follow and then attack again, so it starts moving, but it's still weird
Original source
It's important to differentiate between a query where you expect some form of return, or just an execution where you don't care about the return value
rektbyfaith
11-13-2023, 04:41 PM #17Archived author: Foe • Posted: 2023-11-13T16:41:14.043000+00:00
Original source
It's important to differentiate between a query where you expect some form of return, or just an execution where you don't care about the return value
Original source
If you don't care about the return value, you just async it and let SQL handle it in its own time based on the resources available, keeping queries in some form of buffer is cheap
rektbyfaith
11-13-2023, 04:42 PM #18Archived author: Foe • Posted: 2023-11-13T16:42:07.035000+00:00
Original source
If you don't care about the return value, you just async it and let SQL handle it in its own time based on the resources available, keeping queries in some form of buffer is cheap
Original source
But if it's a simple insert statement, 50k queries per second isn't anywhere near an issue on consumer hardware
rektbyfaith
11-13-2023, 04:43 PM #19Archived author: Foe • Posted: 2023-11-13T16:43:09.093000+00:00
Original source
But if it's a simple insert statement, 50k queries per second isn't anywhere near an issue on consumer hardware
Original source
I shouldn't say consumer, but basic server hardware
rektbyfaith
11-13-2023, 04:43 PM #20Archived author: Foe • Posted: 2023-11-13T16:43:18.890000+00:00
Original source
I shouldn't say consumer, but basic server hardware
1 Guest(s)
1 Guest(s)