Performance between TADODataset & TADOQuery

From: Bill N (bnielsen_at_cpumanagement.com)
Date: 01/21/04 

Date: 21 Jan 2004 07:58:50 -0700

I've heard that it is best to use TADODataset rather than TADOQuery. Why is that? Is there a performance difference between the two?

Bill N

Relevant Pages

  • Re: Performance between TADODataset & TADOQuery
    ... Bill N wrote: ... > I've heard that it is best to use TADODataset rather than TADOQuery. ... Is there a performance difference between the two? ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery or ADOTable?
    ... TADOQuery is ok for querys, but as TADODataset has all the ... > features, ... As per Delphi Help. ... TADODataSet is not capable of issuing Data Manipulation Language SQL ...
    (borland.public.delphi.database.ado)
  • Re: slow refresh of mysql datasets via ADO
    ... the nasty habit to try to load the whole table data. ... TADODataset instead. ... I already got rid of the table. ...
    (borland.public.delphi.database.ado)
  • Re: Changing DB with TADOConnection
    ... >to the new DB and can even oepn up a TADOQuery and manipulate it. ... >However, when I then go to open a TADODataset, I get either a "stack ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery or ADOTable?
    ... a TADOQuery must be used for DML. ... > TADODataSet is not capable of issuing Data Manipulation Language ... > (DML) SQL statements that do not return result sets (like DELETE, ... could be seen as personal POV. ...
    (borland.public.delphi.database.ado)