i have a small clarification.
can we restrict the count query to count only 500 records which match the condition. If not, is there any technique which helps me to achieve the above case.
my code looks something like this
<sql ROW max=10 select statement>
<if $loop eq 0>
<sql count query>
</if>
show results on front end
</sql>
This sql count query takes time when the results to be returned are something like 1,00,0000 records.
Can you suggest me techniques to counter this and save that time.
can we restrict the count query to count only 500 records which match the condition. If not, is there any technique which helps me to achieve the above case.
my code looks something like this
<sql ROW max=10 select statement>
<if $loop eq 0>
<sql count query>
</if>
show results on front end
</sql>
This sql count query takes time when the results to be returned are something like 1,00,0000 records.
Can you suggest me techniques to counter this and save that time.