search

crossdb-org / crossdb

Ultra High-performance Lightweight Embedded and Server OLTP RDBMS✨
https://crossdb.org
Mozilla Public License 2.0
184 stars 12 forks source link

optimization for even more extreme efficiency #33

Closed kolinfluence closed 2 weeks ago

kolinfluence commented 2 weeks ago

i havent really check the code yet but i was thinking your sql prepared statement query, not sure if it can be further optimized for even more extreme performance?

somehow i feel there are opportunities for more performance like 40-60% more.

maybe a crossdbx version for the most extreme efficiency.

it's doable. hope u can think about this for such implementation.

jcwangxp commented 2 weeks ago

If you need extremely speed, you should use hashmap. The language native hashmap is slow, you need to find 3rd library, for example the abseil hashmap. General RDBMS can't be that fast.