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