Forum ‹ BigDB ‹ Size of a BigDB

[johnnyk427]

Is there a way to query how many objects are in a table of bigDB?

[mindbogglegames]

Use can use loadRange as long as there isn't more than 1000 objects in the database. That is the limit that you can return as far as I know. Note that this actually returns all the objects too, so it's kind of messy and bandwidth hog.

Or whenever you store a new object in the table you also have a counter that ticks up, stored in the same table or some other settings table

[Henrik]

In the BigDB admin panel we show how many objects are in each table, and the total size of all the data stored.

However, there are no API methods for counting objects in a table or index.

What functionality are you trying to build?

[johnnyk427]

I'm making a game where players create drawings, and wanted to make a counter '<x> pictures created so far by all players'. Sounds like keeping a separate counter is the way to go, just harder to keep in sync.

[Henrik]

Yes, use a separate counter.

If you want to be really sure your value is in sync, you can use optimistic locking in BigDB, but on the other hand this is a typical value that doesn't have to be accurate, it just has to be in the right magnitude and look believable.