Re: ADO slower than BDE

From: Andrew (abaylis_nos_at_spamcop.net)
Date: 05/26/04 

Date: Wed, 26 May 2004 17:49:58 +1000

I was assuming that you are using a TADODataset. This is preferred over a
TADOTable or TADOQuery.
The Async options can be found in the ExecuteOptions field.

"Denis Dresse" <denis.dresse@decis.be> wrote in message
news:40B34955.8060405@decis.be...
> Sorry, but I do not find such a property : CommandType = TableDirect
> Denis
>
> Andrew wrote:
>
> > If it all comes from one table, try setting the cursor to server-side
and
> > the commandtype to TableDirect. This gives fast sequential access to the
> > table info. Another possibility is to use SQL in an Async mode as there
will
> > be some processing time as you reformat the data for display and the
server
> > can use this to send more records.
> > HTH
> > Andrew
> >
> > "Denis Dresse" <denis.dresse@decis.be> wrote in message
> > news:40B2F2D4.3090702@decis.be...
> >
> >>Thanks for your advices. Here is more information.
> >>
> >>This is a planning application.
> >>A planning shows for example : 2 years x 50 people = 36000 cells... and
> >>for each cell many informations.
> >>Of course this wide information is loaded into the client object model
> >>(in memory) in order to display the planning in a TDrawGrid, with
> >>immediate response time.
> >>The loading can take 30 seconds... for one planning unit (and with ADO,
> >>over 50 seconds) but user is ready to wait in begining of the day.
> >>
> >>So I am not using data-aware components as DBGrid, DBComboBox !
> >>
> >>The loading of this information is made via some SQL and sequential
> >>scanning of large recordset.
> >>
> >>Denis
> >>
> >>Michael Bennett wrote:
> >>
> >>
> >>>Denis Dresse wrote:
> >>>
> >>>
> >>>
> >>>>You mean the CursorLocation = clUseServer
> >>>>instead clUseClient ?
> >>>>
> >>>>I tried this but it was worse (server locked ! I had to kill the
> >>>>
> > application)
> >
> >>>>
> >>>How may records are your queries returning? Have you tried limiting the
> >>>
> > # of
> >
> >>>records returned? (ie setting MaxRecords to 100)?
> >>>
> >>
> >>Anyway I need to transit records from DBServer to the client.
> >>CacheSize and MaxRecords seem to have no impact in this case.
> >>
> >>
> >>
> >>>-Michael Bennett
> >>>
> >>>
> >>>
> >
> >
>