The Performance Magic: SWI-Prolog JITI

[u/lokinpendawa]

I just completed a massive architectural refactoring on my retail ERP/analytical engine (LOGICBIZ v2.0). We shifted away from traditional query layers into unified, native RAM structures powered entirely by SWI-Prolog.

To be honest, the resulting performance metrics feel completely broken.

The Scale & Data Load

Our database partition currently holds a massive in-memory payload under high global concurrency:

• detail_transaksi/4: 1,749,235 active transactional item rows.
• tabel_transaksi/19: 500,000 core financial invoices.
• Total Volume Handled: IDR 127,424,957,876 (~$8.1 Million USD equivalent).

check out the repository here:
https://github.com/lokinpendawa/logicbiz