Count how many rows/records are in an Anvil database table

[ianb]

Also:

@eddie

How can I get a count of how many records are in an Anvil database table?

len(app_tables.table_name.search())

You would think this would take forever, but both the default len() from python, and the len operation as handled by the app tables service written by anvil are super optimized, so it shouldn’t take more than a second with millions of rows.

Also I made this for people who are starting out trying to upload data to anvil to test it out, it leans into how to optimize it yourself without worrying about getting it working first:

CSV to Anvil Data Tables For Beginners with Full Example App

https://anvil.works/build#clone:Z4O2BXJEL6TVJ4QK=2LL4HNW3TZQAG7FICS57W6JN [csvexample] I see many new anvil users struggling to load data sets into the data tables for the first time without having an example of how to avoid abusing the free resources while still loading your use case sample data under the 30 second limit provided by the server modules. So I created this full example app. Feel free to clone it and use it for testing, reference, ideas, or anything else. It is not fast. That’…