Re: COM+ and ADo and performance.

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

Date: Tue, 15 Jun 2004 11:48:50 +0300

Thanks for the answer. I will try what you said.

In client side,
when I insert, delete, update record,
I simply call ApplyUpdates in TClientDataSet.
Is there any other way?

Thanks.

"Vitali Kalinin" <vitkalinin@yahoo.com> wrote in message
news:40ceb45a@newsgroups.borland.com...
> Change CursorLocation to clUseServer and CursorType to ctOpenForwardOnly
it
> should improve performance of select queries. As for Update and Delete you
> don't tell us how you are resolving updates back to DB so it is not easy
to
> suggest something
> "Gürcan YÜCEL" <gyucel@g-gsoft.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
> news:40cb207c@newsgroups.borland.com...
> > 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.
> >
> >
>
>