Hi, We are using firebird embedded in a heavy-multithreaded application, and it works great... on windows... no way to make it work on Linux ----- Original Message ----- From: "Andrew" <[EMAIL PROTECTED]> To: <firebird-net-provider@lists.sourceforge.net> Sent: Friday, August 04, 2006 4:20 PM Subject: [Firebird-net-provider] Multithreading and embedded database
Hello, Do you have experience using embedded firebird into a heavy-multithreaded (multiple concurrent inserts) application? Basically I need to insert data from concurrent incoming TCP connections, the insertion order is not important. First I think I need to buffer the data before inserting it using a lower priority thread in order not to drop the incoming connections. What is the best practice regarding connection management? -- Must I create one connection for each thread? -- Or must I create each thread with the same connection (Singleton) ? I know that creating a connection for each thread is resource costly but is it better for "thread-safety" ? I don't know how FireBird deals with this internally, I've used some others embedded databases in the past like DBISAM which needed to generate a session for each thread. Thank you Andrew -------------------------------------------------------------------------------- > ------------------------------------------------------------------------- > Take Surveys. Earn Cash. Influence the Future of IT > Join SourceForge.net's Techsay panel and you'll get the chance to share > your > opinions on IT & business topics through brief surveys -- and earn cash > http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV -------------------------------------------------------------------------------- > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
