OracleDatasource produce a lot of select count(*)

OracleDatasource produce a lot of select count(*)

Postby 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 ?
hannes_a
 
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Postby 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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for Oracle