sastravel2008
Posts: 9
|
| Posted: 05/09/2011, 3:03 AM |
|
As I understand, to find the number of records fetched by DataSource object the CC make a TWO! query:
One for fetch a table:
it makes a query:
object.DataSource.SQL
and then to get the number of records - second query:
"SELECT COUNT(*) FROM ".object.DataSource.SQL
thats means that object.DataSource.SQL query executed twice.
is it true? i think that this not correctly and require more time
p.s. excuse me for my English.
|
 |
 |
Oper
Posts: 1195
|
| Posted: 05/09/2011, 8:02 AM |
|
True,
and is really a pain on big table or complicated select.
we force the SQL count to no be executed always.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
FrankR
Posts: 154
|
| Posted: 05/09/2011, 9:00 AM |
|
There's a big difference between retrieving all records from a table and asking it to give you a count of rows.
_________________
FR |
|
|
|
|
