[DiscordArchive] Question is, whether I should expect some possible performance impacts if each player would have all
[DiscordArchive] Question is, whether I should expect some possible performance impacts if each player would have all
Archived author: Vel • Posted: 2025-09-22T20:31:43.371000+00:00
Original source
Okay, so theoretically I can just get the max blob index value and add rows for each blob going from 1 to XYZ with max value of `4294967295` to add literally every possible appearance?
```json
[
{
"battlenetAccountId": 1,
"blobIndex": 1512,
"appearanceMask": 4294967295
}
]
```
Archived author: Vel • Posted: 2025-09-22T20:31:56.149000+00:00
Original source
Or it doesn't work like that?
Archived author: Vel • Posted: 2025-09-22T20:44:31.015000+00:00
Original source
Hmh, seems it works however I have no idea what the highest blob index should be Now I am at `9131`.
Archived author: Tea • Posted: 2025-09-22T20:50:42.434000+00:00
Original source
(max id (NOT NUM ROWS) from ItemModifiedAppearance + 31) / 32