I am at a point where I am getting some large result sets and would like to store said result set on the server and fetch the rows one by one. If I use the regular cursor I am able to get the rowcount and everything works fine. However, using SSCursor and then trying to get the rowcount returns a huge number. Are there any nuances of doing server side stores that I am missing. ?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello All
I am at a point where I am getting some large result sets and would like to store said result set on the server and fetch the rows one by one. If I use the regular cursor I am able to get the rowcount and everything works fine. However, using SSCursor and then trying to get the rowcount returns a huge number. Are there any nuances of doing server side stores that I am missing. ?
Yeah.
rowcount() doesn't work on SSCursors until you have fetched all the rows. This is a limitation of MySQL's mysql_use_result().