take()/limit() not available? about laravel-dynamodb

[baopham]

Does it work when you have where conditions?

It is quite inefficient to do a get all in dynamodb. That is doing a limit of 1000 might not really give you 1000 because of the scan limit.

[zoul0813]

Because of how Limit works in DynamoDb, ... it does work with where conditions ... but if your table has 1000 items which might be returned, and a total of 5000 items ... Model::where($condition)->take(1000)->get() may return less than 1000 items ...

To get it to return the 1000 results that would match, we'd have to call the query multiple times using the LastEvaluatedKey until we have >= Limit items to return ... then we only return Limit items in the Collection, discarding any extras. Perhaps taking advantage of 'chunk' ... and changing the while(true) {} or the break; condition to account for the Limit

At the moment, I just needed a way to reduce the number of items being returned as my table has thousands ... and for testing, I only wanted a handful of them.

getAll() is also protected, so I can't call it directly... and chunk still gets all the records, it just processes them in smaller batches using the Limit parameter. So there's no way to just get "X" Items back as one would expect when they call "take/limit".