Trick to load an sqlite DB fast

I am new to SQL and SQLite.

I have a DB that could be big, it would be build once, and consulted many times. The DB could be just a single table (or a little number of table), but with huge number of rows.

I'd like to know if there is a mode (or technic) to load the monster table, I guess indeed the ASYNC mode + TRANSACTION opened, but is is logical to open a transaction for millions of row?

Would it be possible for the load phase (or initial construct) that is mono threaded, to avoid journaling, locking, and simply stuff rows in there (insert) massivly ?