SQLite Forum

Android and desktop Java library
Login
> Phone cores are slower, but phone has more cores. Is possible run one transaction on more than one core in SQLite.

Transaction is mostly an I/O operation. SQLite may [perform sorting in parallel][1] if you enable [the option][2], but more CPU cores won't be able to speed up I/O. Indeed, I/O is so much slower than CPU that we had invented caches for our storage devices in memory. Also, memory is so much slower than the CPU that there are memory caches in the CPU, usually multiple levels of them.


[1]: https://sqlite.org/c3ref/c_config_covering_index_scan.html#sqliteconfigpmasz

[2]: https://sqlite.org/pragma.html#pragma_threads