Speeding up Queries that have CachedUpdates
Posted on 1998-09-04
Using Delphi 3, BDE 4.51 to get at paradox/foxpro tables with LocalSQL.
Recently, I had to move my Queries over from live to CachedUpdates. As soon as I set the TQuery.CachedUpdates property to True, the performance slows to a crawl.
Are there some settings that speed that up? Either in the BDE or an object?