Slow performance with TADOTable.Post

From: Gabriel Ballesteros (sistemascycllantas_at_epm.net.co)
Date: 02/24/04

  • Next message: Viatcheslav V. Vassiliev: "Re: What am I missing?" 
    Date: Tue, 24 Feb 2004 12:14:34 -0500

    Hello,

    I'm developing any application with Delphi5 and MySQL 4,0,15 maxdebug. I'm
    use MySQL ODCB 3.51.06 with ADO components to connect MySQL .

    I have the following piece of code :

    AdoTable1.Open;
    while not AdoTable1.Eof do
    begin
        AdoTable1.Edit;

    AdoTable1.FieldByName('salary').AsFloat:=Table1.FieldByName('salary').AsFloa
    t *
    1.5;
        AdoTable1.Post; // Here exists slow performance.
        AdoTable1.Next;
    end;
    AdoTable1.Close;

    The problem is that when invoking the edit and post methods the application
    present slow peformance.

    The same piece of code using TTable(BDE) executing with high performance.

    The table having 3000 records and having defined primary key in the
    indexname property.

    Excuse me for my English.

    Gabriel Ballesteros
    Medellín - Colombia

  • Next message: Viatcheslav V. Vassiliev: "Re: What am I missing?"

    Relevant Pages

    • Re: Newbie- Can I create a new MySQL database from within my app?
      ... > I'm trying to find out a bit about MySQL and Delphi. ... > tutorials about accessing existing databases from within a client ... > components or the ADO components to access tables or to perform ... > queries on a MySQL database." ...
      (alt.comp.lang.borland-delphi)
    • MySQL text field lengths truncated
      ... I'm new to MySQL development. ... I'm using Delphi 7, ADO components, connecting ... to a remote MySQL server 4.1.10. ...
      (borland.public.delphi.database.ado)
    • Slow performance TAdoTable.Post
      ... I'm developing any application with Delphi5 and MySQL 4,0,15 maxdebug. ... use MySQL ODCB 3.51.06 with ADO components to connect MySQL. ...
      (borland.public.delphi.database.ado)