How to implement cass_result_last_row()?

[Jacek]

Hi,

I'm looking for sth like cass_result_last_row() which will return last row from CassResult. Is it possible (somehow) now?

-Jacek

[Michael Penick]

Hi Jacek,

With the current API your application could create a result iterator and iterate to the last row. I admit this isn't ideal, esp. if you don't want the data in the intermediate rows (between the first and the last rows). I'm not opposed to adding a  cass_result_last_row() (or a cass_result_nth_row()), because it would be faster to do this in a tighter loop.  However, it's important to understand that the cost depends on the number of rows being skipped. Rows are not fixed length so you'd have to calculate the offset and traverse each row in the result set to get to the end. 

If you could add a story to the cpp-driver JIRA [1] with some details it would be greatly appreciated. 

Cheers,

Mike

[1]: https://datastax-oss.atlassian.net/secure/Dashboard.jspa

-Jacek

--
You received this message because you are subscribed to the Google Groups "DataStax C++ Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cpp-driver-us...@lists.datastax.com.

[Michael Penick]

Here's a potentially better way to handle this:

Could you reverse your result set and using "ORDER BY <column> DESC LIMIT 1" then use cass_result_first_row()?

Mike