Re: COM+ and ADo and performance.

From: Vitali Kalinin (vitkalinin_at_yahoo.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 11:32:39 +0300

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.
>
>

Relevant Pages

  • Re: Managing multiple queries
    ... Maybe creating a stored procedure will help you. ... Then you would need just to execute the stored procedures in Query Analyzer (which is the tool intended to run queries anyway). ...
    (comp.databases.ms-sqlserver)
  • Re: embedded in strings
    ... The thing that had me going was that the same queries worked fine insql ... query analyzer if you want to see what I'm talking about. ... > Can you explain a little better how it throws a null reference exception? ... > | I'm having problems with queries like the following in sqlserverce. ...
    (microsoft.public.sqlserver.ce)
  • Re: iis/asp + sql2000 a bit slow
    ... > I have a performance problem, but I don't really know where the exact ... > I ran every single on of these queries with the SQL Query Analyzer, ... All queries run superfast, so I'm ...
    (microsoft.public.inetserver.asp.db)
  • Re: embedded in strings
    ... queries with vaues longer than the column being queried. ... I guess I could send you the sqlce database so you can test it. ... > | the null reference exception. ... > | query analyzer if you want to see what I'm talking about. ...
    (microsoft.public.sqlserver.ce)
  • Re: Is sql server as good as access 97?
    ... Once you really get into using Query Analyzer for writing your ... Transact-SQL and for formulating 'queries' for exporting to your code, ... resulting stored procedure runs in a small fraction of the time it took to ... Unfortunately the database I am converting ...
    (microsoft.public.sqlserver.programming)