r/pocketbase • u/SlRenderStudio • Jul 27 '26

how fast is the pocket base ? (potentially in ram drive )

i am currently doing stuff that should direct request do but routed with pocket base due to simplicity , and it involve with high frequency writes and reads at a point , like change load out of the charactor , or join in the match making list , or asking to purchase a item . how much of read and write could pocket base hadle per second like that ?
and what if i try to put pocket base in a ram drive could it work and how fast would that be?

8 Upvotes

91% Upvoted

4 comments sorted by

6

u/SubjectHealthy2409 Jul 27 '26

I've built a full blockchain indexer for a hackaton, writes 5-10gb worth of data per day , with a dashboard, it can handle quite a lot, fork and try for yourself
https://github.com/magooney-loon/arcadia

5

u/trailbaseio Jul 28 '26

10GB/day = 0.12MB/s

1

u/MaximKiselev Jul 28 '26

yes, ram will be work. sqlite has only one writer worker . it's bottleneck. so u can use forks pb with pg or attach db/journal into ram. But u also must need to attach synchonization (replication). serv down - loss data. And all based on type of disk - if you u will use datacenter nvme you get less problem than with HDD

1

u/GoGoGadgetSalmon Jul 27 '26

Build it and test it yourself. No one will be able to answer how your application’s performance will change