basic remtoing question

From: MR (nospam)
Date: 04/15/04


Date: Thu, 15 Apr 2004 10:07:21 +0300

i would like to organize a db-layer so that all sql related code (ado.net)
exists in a single namespace in a single dll. the dll will then be
accessible via remoting. i expect that the remoted object will be quite busy
and response time is super-critical (250ms)
the questions i have are as follows:
0) if i create it as a singleton, does the entire object become single
threaded or is each method single threaded. or is it better to create it as
a single use object? (the disadvantage of a single use object is that it
would have to go thru a small initialization procedure each time i.e. read a
config file to get the name of the sqlserver and database, open the
connection, etc.)
1) is it advisable to have all 30 methods in one dll or should i split it up
into individual dlls (a pain to maintain)