On Fri, Nov 5, 2010 at 2:47 PM, Chris Vernor <[email protected]>wrote:
> I am fairly new to the SQLite world, and have a quick question: > > > > I have an application that migrates files form a windows environment to > a solaris environment, and it can be run multi-threaded. I have seen > several articles that show apps opening and closing the connection with > each Query or Insert, and other that establish a connection once and > hold it open until a thread completes. What would be the better method > for this? > > Hold the connection open. There is a small but non-trivial cost to opening and closing connections. > > > Thanks, > > Chris > > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
