Re: TADO vs. TQuery

Thank you all for your replies. I have a fairly efficient and normalized
database, and I always only select the columns I need, and use many where
clauses as well. Indexes are set up too.

I guess there is no need to convert anythingt to ADO then.

Allan


"Del M" <Del.Murray@xxxxxxxxxxxxxx> wrote in message
news:42b8c766@xxxxxxxxxxxxxxxxxxxxxxxxx
> Maurice is absolutely right. Most of your speed will depend on your
> database, query plan, not selecting unused columns, indexes, size of
result
> set, cursor location, bandwidth, data types, ..... etc. All that is mostly
> on the database and in your coding techniques.. A bad database design and
a
> bad query will kill both ADO or any other access method.
>
>


.

Relevant Pages

  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Requery of Listbox does not display new data
    ... add a record to the database. ... Then the Lisbox control's requery method is ... The ADO command is run using a connection string to the mdb containing the ... Dim cmd As ADODB.Command ...
    (microsoft.public.access.formscoding)