[sqlite] cost of sqlite3_open

Hi, I'm working on a multi-threaded image server and I have 2 questions: 1) How "expensive" is a call to sqlite3_open. Does a call to sqlite3_enable_shared_cache make it "cheaper"? 2) If sqlite3_open is an expensive operation then I would like to keep a list (cache) of open database

[sqlite] sqlite3_open expensive?

hi! how expensive is sqlite3_open? i'm working on a small (one-thread-per-connection) server. is it smart (in terms of cpu-time and memory usage) to use sqlite3_open for every connection or is it better to create a pool of pre-opened sqlite-connections? regards, luky ps: