Borland Delphi & Oracle

From: Eric Baardman <baardman_at_cistron.nl>
Date: 1998/03/15
Message-ID: <01bd5046$e557a0e0$a24540c3_at_eagle>#1/1


Hello

I've encountered the following problem:

I have a query statement containing 9 sub-queries and several virtual columns (columns that don't exist in the database, but can be used to store temporal status information). One of the subqueries makes use of 15 tables. The result set contains 36000 records. When I browse through the result set the performance is OK, but when I change a record and apply it to the database, the scrolling becomes slower. In fact after every modification, the application gets slower. After a re-query everything is back to normal.

If I don't apply the modification to the database and give a cancelupdates command, the application performance is also back to normal.

It seems that BDE has a problem with 'walking' through result sets in combination with things written in the cache. I've contacted Borland and they acknowledge it is a bug. They discovered the same problem with Interbase (I use Oracle). However a solution is still not available!

Does anyone has had the same problem and if so what solution did you come up with. Is there may be a good alternative for the Borland BDE?

I use Delphi 3.0 C/S and Personal Oracle 7.3.3.0.0 on a W95 platform. The latest version of Delphi (3.02) doesn't help to solve this problem.

Thanks in advance Received on Sun Mar 15 1998 - 00:00:00 CET

Original text of this message