Hi
i have a strange problem:
i use code like this:
ODBCConnection cnn = new ODBCConnection("... cnn string ...");
ODBCDataAdapter da = new ODBCDataAdapter("select * from tbl left join tbl2
on tbl.refid = tbl2.id", cnn);
DataTable dt = new DataTable;
DateTime t = Now();
da.Fill(dt);
TimeSpan ts = Now.Substruct(t);
Trace....... Show the ts.
......
i use this code in 2 programs:
(the remoting server is a console app.)
position:
Time
1. remoting server program on a marshaled object
in static method.
8.7 seconds.
2. the same server, but in the main file.
5.4 seconds
3. the client, in the remoting object (the same
method as 1, but i know here it is not the same
remoting object).
4.2 seconds.
4. different console program( that not using any
remoting, built to the test.)
0.5 second !
u see a huge changes between these methods.
I operate the 2 programs (remoting and test) concurrently and the results
was the same +-.
so i assume it is the remoting that affect the Fill method.
but why ??
what could be the reason ??
if any1 want i will send him the remoting configuration section in the
config file so he might watch it...
|