Counting entities in dynamodb

[Tamrael]

laravel-dynamodb/src/DynamoDbQueryBuilder.php

Line 562 in b87ef60

return $this->getAll($this->model->getKeyNames())->count();

Today we started using this class on one of our live products where we used dynamodb for simple logging only (reads on topics).

We only ever post the entry when the user reads the topic and read back a "read count" to display with each topic in the overview.

We had very low read and write rates before but after half a day of using the models instead of raw queries our read provision rates went trough the roof.

Turns out SomeModel::where('someField', $someValue)->count() doesn't actually result in a "Select" => "COUNT" statement to dynamodb but instead fetches all records and counts the collection.

Any chance this could be fixed?

Without a fix there is no point in using the model because all the clean code in the world can't justify a 50x increase in read provision rates

I'm willing to contribute a PR if wanted

[baopham]

Ah yes, the count was done long time ago during POC time and I forgot about it. Hold on, let me see.

[Tamrael]

Thank you for the quick response. Let me know if i can help in any way

For reference: https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html#DDB-Query-request-Select is the doc part describing COUNT.

[baopham]

Will release a new version once Travis is green.

[baopham]

Thanks for the report. The fix is now in version 4.2.3.

[Tamrael]

Thanks. Works like a charm. Keep up the great work