Get all records

deca · Post by **deca** » Wed 23 Apr 2008 14:45

Hello at all,

I implemented the ODAC component to the application. I load the records to my OraQuery via SQL statement: SELECT * FROM Table

But the result is that not all records has been taken to the query. I tried some settings on the OraSeccion but no changes.

Thanks for help.

Regards, DECA

Plash · Post by **Plash** » Thu 24 Apr 2008 07:55

Please specify how do you see that the query does not return all records. Maybe setting the FetchAll property of TOraQuery can help.

deca · Post by **deca** » Thu 24 Apr 2008 08:10

Ohh, I see. There is an entry "FetchAll" on the OraQuery. I allways searched for this setting in the OraSeccion. In this case has the property "FetchRows" any signification if FetchAll = true?

The next what really disturbs is, the table I'm calling has a blob field. And it takes about 9 minutes to get all records (about 9000 records). That cannot be serious.

Are there any other settings or what can I do to accelerate getting all records?

Plash · Post by **Plash** » Fri 25 Apr 2008 08:20

The FetchRows property is used also when FetchAll = True. Records are fetch by blocks. The FetchRows property determines the number of records in one block. Setting a larger value to the FetchRows property can slightly increase performance of fetching. But this also increases memory usage during the fetch.

To open a table with a BLOB field faster, set the DeferredLobRead option of TOraQuery to True.