Hi,
We´re testing your dbExpress driver for Oracle because we´ve started to migrate our application from FibPlus components to dbExpress and we´d like to use both SQL Server and Oracle. For SQL Server, your driver seems to fit perfectly to our application on the tests we´ve done, but for Oracle the problem we´ve found is on the "Load on Demand".
The issue happens when we have large results (lots of records) and we set the PacketRecords property to 1 or more.
For example, we have here a table with 690000 records, it is a zip-code table, and we made a test in this table to test performance and the load on demand. We set a SQLDataSet with the command "SELECT * FROM TABLE" and the ClientDataSet with PacketRecords = 1. If you move forward, record by record, some time it will stop to move forward, because the EOF property is set to True misteriously, but if you move backward only 1 record, you can go forward more records until it stops again.
It doesn´t happen only with PacketRecords = 1, it happens if I set the PacketRecords less than 55000. If I use this "magical" number it works. The higher the number I set, further it goes without stop.
To this test, we made a simple application: TCRSQLConnection, TSQLDataset, TDataSetProvider, TClientDataSet, TDataSource and TDBGrid. We are testing here with Oracle 11g Express R2 and Delphi 2006.
We made the same test with the Oracle dbExpress default driver in Delphi and it works well in this case. But the Oracle dbExpress default driver doesn´t fit our needs, it has a lot of other problems.
Do you guys know something about this??
If I wasn´t clear enough, please let me know.
Thanks in advance.
PacketRecords
-
- Posts: 6
- Joined: Mon 24 Oct 2011 02:24
Hello
We tested your sample application on Oracle 10g, Oracle 11g, and Oracle 11g Express edition. Also you didn't specify which version of dbExpress driver you tested. Is it the latest version? Please provide us the exact and full version of your dbExpress driver (for example, dbExpress driver for Oracle ver. 5.1.2).
We tested your sample application on Oracle 10g, Oracle 11g, and Oracle 11g Express edition. Also you didn't specify which version of dbExpress driver you tested. Is it the latest version? Please provide us the exact and full version of your dbExpress driver (for example, dbExpress driver for Oracle ver. 5.1.2).
-
- Posts: 6
- Joined: Mon 24 Oct 2011 02:24