[DiscordArchive] how long for inserting 2B rows ?
[DiscordArchive] how long for inserting 2B rows ?
Original source
how long for inserting 2B rows ?
rektbyfaith
11-13-2023, 05:38 PM #1Archived author: Rymercyble • Posted: 2023-11-13T17:38:39.415000+00:00
Original source
how long for inserting 2B rows ?
Original source
shouldn't be too long
rektbyfaith
11-13-2023, 05:38 PM #2Archived author: Foe • Posted: 2023-11-13T17:38:55.853000+00:00
Original source
shouldn't be too long
Original source
well technically i think 4.4B
rektbyfaith
11-13-2023, 05:39 PM #3Archived author: Rymercyble • Posted: 2023-11-13T17:39:20.157000+00:00
Original source
well technically i think 4.4B
Original source
account char and guild
rektbyfaith
11-13-2023, 05:39 PM #4Archived author: Rymercyble • Posted: 2023-11-13T17:39:23.883000+00:00
Original source
account char and guild
Original source
Well I have implemented the config now
rektbyfaith
11-13-2023, 05:41 PM #5Archived author: Kitzunu • Posted: 2023-11-13T17:41:02.365000+00:00
Original source
Well I have implemented the config now
Original source
Thank you everyone for answers, especially **Foe**. Dude says clever things <:pepesmort:1107643564294422559>
rektbyfaith
11-13-2023, 05:43 PM #6Archived author: 2_uah • Posted: 2023-11-13T17:43:52.225000+00:00
Original source
Thank you everyone for answers, especially **Foe**. Dude says clever things <:pepesmort:1107643564294422559>
Original source
But yeah, your fix is to increase the limit for CMSG_GUILD_SET_OFFICER_NOTE in WorldSession.cpp
rektbyfaith
11-13-2023, 05:45 PM #7Archived author: Foe • Posted: 2023-11-13T17:45:43.181000+00:00
Original source
But yeah, your fix is to increase the limit for CMSG_GUILD_SET_OFFICER_NOTE in WorldSession.cpp
Original source
```C++
case CMSG_GUILD_SET_PUBLIC_NOTE: // 1 2 1 async db query
case CMSG_GUILD_SET_OFFICER_NOTE: // 1 2 1 async db query
case CMSG_SET_CONTACT_NOTES: // 1 2.5 1 async db query
{
maxPacketCounterAllowed = 50; // Change this value to whatever cap works for you
break;
}
case CMSG_CALENDAR_GET_CALENDAR: // 0 1.5 medium upload bandwidth usage
case CMSG_GUILD_BANK_QUERY_TAB: // 0 3.5 medium upload bandwidth usage
case CMSG_QUERY_INSPECT_ACHIEVEMENTS: // 0 13 high upload bandwidth usage
case CMSG_GAMEOBJ_REPORT_USE: // not profiled
case CMSG_GAMEOBJ_USE: // not profiled
case MSG_PETITION_DECLINE: // not profiled
{
maxPacketCounterAllowed = 50;
break;
}```
rektbyfaith
11-13-2023, 05:46 PM #8Archived author: Foe • Posted: 2023-11-13T17:46:38.522000+00:00
Original source
```C++
case CMSG_GUILD_SET_PUBLIC_NOTE: // 1 2 1 async db query
case CMSG_GUILD_SET_OFFICER_NOTE: // 1 2 1 async db query
case CMSG_SET_CONTACT_NOTES: // 1 2.5 1 async db query
{
maxPacketCounterAllowed = 50; // Change this value to whatever cap works for you
break;
}
case CMSG_CALENDAR_GET_CALENDAR: // 0 1.5 medium upload bandwidth usage
case CMSG_GUILD_BANK_QUERY_TAB: // 0 3.5 medium upload bandwidth usage
case CMSG_QUERY_INSPECT_ACHIEVEMENTS: // 0 13 high upload bandwidth usage
case CMSG_GAMEOBJ_REPORT_USE: // not profiled
case CMSG_GAMEOBJ_USE: // not profiled
case MSG_PETITION_DECLINE: // not profiled
{
maxPacketCounterAllowed = 50;
break;
}```
Original source
https://github.com/azerothcore/azerothco....cpp#L1499
rektbyfaith
11-13-2023, 05:46 PM #9Archived author: Foe • Posted: 2023-11-13T17:46:50.364000+00:00
Original source
https://github.com/azerothcore/azerothco....cpp#L1499
Original source
Change this to that and change the maxPacketCounterAllowed to some reasonable number
rektbyfaith
11-13-2023, 05:47 PM #10Archived author: Foe • Posted: 2023-11-13T17:47:03.792000+00:00
Original source
Change this to that and change the maxPacketCounterAllowed to some reasonable number
1 Guest(s)
1 Guest(s)