girinovey on Nostr: made a little benchmark project: 1- lmdb is really slow to store events. It took 12s ...

made a little benchmark project: https://github.com/girino/eventstore-benchmark
1- lmdb is really slow to store events. It took 12s to store 1000 events. Due to this high preparation time, i tested with only 1000 events (will do bigger tests as soon as lmdb finishes loading all my events).
2- I did not use indexes in slicestore (used the original by fiatjaf).

The table below shows the times for 100 executions of each filter.

My conclusions:
1- Store is orders of magnitude slower in lmdb and this might be the problem i have in raspberry pi. Not querying.
2- non indexed queries are faster in slicestore (limit only and by kind where the index is amost useless)
3- indexed queries are a little faster in lmdb, but not by much. Will probably be slower when i use indexes in memory.

*** This is preliminary data, just for fun, since i have only 1000 events ***