Possible to get a record count from find without transferring the whole result set?

[Cedric Tineo]

I am currently using this to get a record count of a found set after
a .find

@record_count = @my_layout_light.find({
"status_published" => 'OK',
"composite_name" => @name,
{:include_portals => true}
).size

The problem is that it forces RFM to retrieve the entire result set,
that's all the fields of the used layout for all the records of the
found set - in its xml form to ruby / nokogiri - and only after all
that has been processed, it is available for the .size method...
Needless to say that on large found set of a few thousands, this takes
many_many seconds to process.

Since I only want a record count to display "Your search returned XXX
results" and I'm only displaying 10 at a time on a page - it's a waste
of time to have to transfer the whole set - just for a record count.

Any other way to do that?

[lardawge]

@record_count = @my_layout_light.find({
"status_published" => 'OK',
"composite_name" => @name},

{:include_portals => true,
:max_records => 10}
)

@record_count.foundset_count

Hope that helps.

[Cedric Tineo]

Brilliant! Thanks!

Just out of curiosity - in which part of the doc should I have looked
to find out about that?

Thanks again, Cedric