Performance Issues Working with Anvil Data Tables and Row Iterators

[rickhurlbatt]

I have just tested this method

@danbolinson

I always get terrible performance when I do this, even on the server side:

filtered_results = [x for x in product_data]

and it seems linked to the type of plan you are on. I am presuming that if you are not on a dedicated server where the data tables and app exist on the same server, performance could be slow.

If you are on a dedicated plan with app and tables on the same hardware, creating a list of rows in this way adds almost no overhead (like less than 0.0001 seconds on top of a search that takes 4 seconds to search)