COM+ and ADo and performance.

From: Gürcan YÜCEL (gyucel_at_g-gsoft.com)
Date: 06/12/04 

Date: Sat, 12 Jun 2004 18:28:08 +0300

Hi,
Im using D7 ent, COM+ on W2K sp4 installed and MS SQL Server 2000 with
appropriate service packs.

I wrote 3 tier application which business logic on COM+ objects. I simply
used a TADOConnection(ConnectOption=coConnectUnspacified,
CursorLocation=clUseClient, IsolationLevel=ilCursorStability,
KeepConnection=True, Mode=cmUnknown) and TADOQuery
(CursorLocation=clUseClient,
CursorType=clUseClient,CursorType=ctStatic,LockType=ltOptimistic,
MarshalOptions=moMarshalAll, Prepared=False) on server side. There is also
TDataSetProvider(Options=[],ResolveToDataSet=False,
UpdateMode=UpdateWhereAll) that point TADOQuery. In client side
TDCOMConnection connected to COM+ object and
TClientDataSet(FetchOnDemand=True, ObjectView=True,StoreDefs=True) for using
database stuff. There is no transactions used. EveryWhere I used point
queries and there is no more than 5-10 records at a time. Also I used
standart data types (no image, text, ntext etc.) And also column count is
not more than 10.

Everything is work fine when there is small amount of users. But, when
amount of 20-30 users connect to server and begins to insert record it slows
down. I simply write the same query in Query Analyzer. It takes 0.024sec to
execute. But When I execute the same insert query from TClientDataSet, it
takes 3-4 secs.!!!! (Also in select, delete and update it takes 3-4 secs)
There is no batch update. Every time single row.

I cant figure out why. I installed COM+ objects with Query analyzer to test
network speed other than SQL Server machine. The problem is same. Is there
anyone who can help me? (I also write the general VCL properties that I set)

Thanks.

Relevant Pages

  • Re: SQL 7.0: Beim Erstellen einer SP ANSI_NULLS und ANSI_WARNINGS Fehler
    ... Dirk Soetebeer schrieb ... ... > es sollen Daten von einem Verknüpften Server via SP geladen werden. ... > Beim Ausführen in Query Analyzer funktioniert alles ordnungsgemäß. ...
    (microsoft.public.de.sqlserver)
  • Re: Add Global Group to Database
    ... It seems one has to open explicit a new server/database connection by Query Analyzer. ... print 'Du bist *nicht* in Rolle role_JHTestrolle' ... > I am trying out several user access drafts in SQL Server 2000. ... > - Add this global group to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Connection Broken Error
    ... I am not on server, i am running cursor from my m/c in query analyzer. ... client net work utility ...
    (microsoft.public.sqlserver.programming)
  • Re: isnumeric-error in result, attn Microsoft
    ... > I close Enterprise Manager and Query Analyzer, ... > Changes to the server since it last worked correctly ... > ODBC configuration changes to ensure Regional settings and OEM/ANSI ...
    (microsoft.public.sqlserver.programming)
  • Re: the connection to the server has been broken
    ... connecting with Query Analyzer as you used to register SQL ... Server in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)