|
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
