Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
- Posts: 77
- Joined: Sun 22 Jan 2006 20:44
- Location: munic
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 ?
- Devart Team
- Posts: 1710
- Joined: Thu 03 Dec 2009 10:48
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.