Re: ADOQuery slow

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 02/26/05

  • Next message: Brian Bushay TeamB: "Re: Records are not displayed in DBGrid" 
    Date: Fri, 25 Feb 2005 20:56:00 -0600

    >I am converting BDE to ADO. One ADO query was executed one hundred times
    >(with different parameters), each time it got a record from the database
    >(ORACLE 8.1.7/ASA 6.0). It took about 2 seconds for fetching these 100
    >records. However, if I use BDE for Oracle and Sybase or Direct Oracle
    >Access for Oracle only, it likes a blink of eyes.

    BDE query does some buffering so you see records returned before the query
    completes. ADO clientside cursors fetch all records.
    Are you fetching a large number of records? If that is the case change your SQL
    to select just the records you need.
    You can also gain some speed by using DisableControls on the dataset your are
    using Before you open it and EnableControls after the Open. 

    --
Brian Bushay (TeamB)
Bbushay@NMPLS.com
  • Next message: Brian Bushay TeamB: "Re: Records are not displayed in DBGrid"

    Relevant Pages