Hello All, I am using SQLite in one my application and I require to retrieve around 4-5 sets of information simultaneously. I have opted to run the queries in separate threads which seems obvious choice here.
However, I came to know from one of the documents in sqlite.org that single connection cannot be used simultaneously across threads. So I would like to hear any suggestions regarding the best wary to open & manage multiple connections i.e. a) Is it efficient to create new connections in separate thread each time when the query needs to be executed? ( Here I am worried about the time taken to open connection ) b) Is it efficient to create the number of connections required, in a single thread and use it in different threads? ( although a connection will not be used simultaneously and this will eliminate the effort to create different connections but we need to ensure that a connection is used simultaneously in different threads) Looking forward to your suggestions, Bharath Booshan L ----------------------------------------------- Robosoft Technologies - Come home to Technology Disclaimer: This email may contain confidential material. If you were not an intended recipient, please notify the sender and delete all copies. Emails to and from our network may be logged and monitored. This email and its attachments are scanned for virus by our scanners and are believed to be safe. However, no warranty is given that this email is free of malicious content or virus. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
