OracleDatasource produce a lot of select count(*)

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
hannes_a
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

OracleDatasource produce a lot of select count(*)

Post by hannes_a » Sat 20 Aug 2011 13:22

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 ?

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Wed 24 Aug 2011 13:24

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.

Post Reply