Devart Forums

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

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

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?

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.