Re: Cassandra Driver Pagination

2018-04-25 Thread Andy Tolbert
Hi Ahmed, It does not, it only reads enough rows to satisfy the clients request. Although, that may be a bit of an oversimplification as it has to scan through sstable files, read indices, pass over tombstones and so on, but it will stop reading new rows once it has read the number of rows the

Re: Cassandra Driver Pagination

2018-04-25 Thread Ahmed Eljami
Hi Andy, Thanks. When the driver requests X rows, C* will load the whole partition (All rows) before reply to driver ? Thanls. 2018-04-24 18:11 GMT+02:00 Andy Tolbert : > Hi Ahmed, > > The java driver docs do a good job explaining how the driver uses paging, >

Re: Cassandra Driver Pagination

2018-04-24 Thread Andy Tolbert
Hi Ahmed, The java driver docs do a good job explaining how the driver uses paging, including providing a sequence diagram that describes the flow of the process: https://docs.datastax.com/en/developer/java-driver/3.5/manual/paging/ The driver requests X rows (5000 by default, controlled via

Cassandra Driver Pagination

2018-04-24 Thread Ahmed Eljami
Hello, Can someone explain me how paging is implemented ? according to the doc of datastax, the goal being to avoid loading much results in memory. Does it mean that the whole partition is not upload to heap memory? ​C* version: 2.1 Java Driver version: 3.0 ​Best regards​