Hi All,
I have a query regarding SQLite usage as follows. Any pointers will be
really helpful.
My application presents multiple threads of provisioning to user. SQLite
database is used to keep audit logs (change logs storing the user name,
time, operation done etc.). Now, the way we have implemented it is to
keep opened database handle in the form of sqlite3* pointer per thread
i.e. each time some thread gets a request it does following :
a. check if there already is any sqlite3* opened already in this thread.
b. if yes, use it.
c. if no, call sqlite3_open and store the returned handle in a map
for future uses.
Is this correct usage ? Will it give any optimization over opening and
closing database handle everytime ? Will it result in delay in flushing
to the hard disk ?
I am also seeing files will junk extensions in the directory. What are
these files ?
Thanks,
Regards,
Aseem.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
