vibe.d + dpq2 + json trick

Robert Schadek rburners at gmail.com
Wed Aug 20 16:06:10 UTC 2025


On Wednesday, 20 August 2025 at 14:10:31 UTC, Denis Feklushkin 
wrote:
>
> Also, I added PREPARE, row-by-row read for /normal (just for 
> check if it helps) and replaced "id" by [0] on column accessing 
> code
>
> Nothing really helped
>
> My measurements:
>
> ab -n 10000 -c 10 localhost:8080/oldschool Requests per second: 
>    675.46 [#/sec] (mean)
> ab -n 10000 -c 10 localhost:8080/normal Requests per second:    
> 163.55 [#/sec] (mean)
> ab -n 10000 -c 10 localhost:8080/special Requests per second:   
>  3636.42 [#/sec] (mean)

I haven't checked by I bet postgres caches parsed/optimized 
queries. And the test would have a nearly perfect cache hit ratio


More information about the Digitalmars-d mailing list