SQLite Forum

Android and desktop Java library
I have today written simple wrapper for libraries and test the same code on Laptop Core I3 8th Gen and Samsung A42.

I create 10'000 rows , each with column "to jest text" and float. Moreover I add two indices, unique for column 2 and not unique on column 1+2.

First I have 22 seconds on laptop; I make one transaction and I have only 150 ms.
On Samsung phone 1000 ms.

Why? Phone cores are slower, but phone has more cores.
Is possible run one transaction on more than one core in SQLite. Is possible further optimization in Java?