PC Review


Reply
Thread Tools Rate Thread

dataadapter fill performance problem

 
 
Yair Cohen
Guest
Posts: n/a
 
      17th Feb 2004
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...







 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem with range in DataAdapter.Fill =?Utf-8?B?YmFyZG8=?= Microsoft C# .NET 0 8th Feb 2005 01:45 PM
dataadapter fill performance problem Yair Cohen Microsoft ADO .NET 0 17th Feb 2004 07:49 PM
dataadapter fill performance problem Yair Cohen Microsoft Dot NET Framework 0 17th Feb 2004 07:49 PM
DataAdapter.Fill problem Sébastien Microsoft ADO .NET 12 3rd Feb 2004 03:00 PM
DataAdapter.Fill method problem Vivek Microsoft ADO .NET 1 28th Oct 2003 01:14 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:29 AM.