Devart Forums

OracleDatasource produce a lot of

select count(*) (select * from xyz /*my ordinary query*/)

for understanding: which part needs the affected rows ?
when I don't need it, can I stop this ?

These statements are necessary for data paging: OracleDataSource needs the total count of rows in the result set to count the page number.

If you are displaying fetched data on a single page, you can disable paging (set the 'DataPagingMode' property of OracleDataSource to 'Disabled') to cancel these additional queries.