I am a newbie for SQLite and I have read that the Serialized mode of SQLite is thread-safe, and can be safely used by multiple threads with no restriction.
My question is: In a single-threaded app, is there any performance impact if I use one same global connection for all database operation comparing to using one connection per database operation?(Ignore the performance impact for building db connection)
To be specific, imagine such a scenario: in the same thread, I need build two prepared statement to query two table respectively in the same dababase, and I need use STEP() to retrieve data from the two statement alternatively. My question is which will have better performance: I. Using one same connection for both statement; II. one connection per statement?(not account for the performance impact occurred in the process of building connection) Or is it necessary to use a connection pool for performance benefit?