long fied and readbuffer in Toraclewwdataset

[ziller]

hello,

i have a query like this :

select rowid,i.itemid, i.blobfield
from table mytable i

where mytable contains about 250 rows and blobfield is of type long in oracle

but this is very slow even if i set the readbuffer property to 1.

how to set speed up this query?

regards

 

[Marco Kalter]

You can set QueryAllRecords to False to prevent that all records will be retrieved.

You can alternatively omit the LONG field from the query, and fetch it when you need it.

------------------
Marco Kalter
Allround Automations