vibe.d + dpq2 + json trick

[Dmitry Olshansky]

On Thursday, 21 August 2025 at 10:31:18 UTC, Serg Gini wrote:
> On Wednesday, 20 August 2025 at 16:06:10 UTC, Robert Schadek 
> wrote:
>> On Wednesday, 20 August 2025 at 14:10:31 UTC, Denis Feklushkin 
>> wrote:
>>>    [...]
>>
>> I haven't checked by I bet postgres caches parsed/optimized 
>> queries. And the test would have a nearly perfect cache hit 
>> ratio
>
> I wonder with values will valkey show.
> Another thing that ab tool will send the same request and the 
> same ID will be requested over and over again.
>
> Maybe if create let's say 1000 ids and every request then 
> calculating random(1,1000) and use it for data extraction, it 
> will show a bit more realistic values.

ab is old and single threaded, use wrk it’s multithreaded and 
supports lua scripts to generate requests.