HubDB call count for foreign ID

Develop, Build & Integrate CMS Development
1

I understand there’s a limit to the amount of times you can call a HubDB table. Could someone please clarify the following:

  1. Is the 10 limit per module or per page?
  2. When using a foreign ID to bring in data from another table, does this count as a new call?
  3. Can a foreign ID be ‘daisy-chained’ for example table A needs to be linked to table B, which itself also needs to be linked to table C. Can table A bring in data directly from C via B? If so, how would this be coded?

Thanks

2

Ben, per the documentation below (and I’ve run up against it in practice, too), it’s 10 calls to hubdb_table_rows per page.
afaik. foreign ID relationships don’t re-invoke hubdb_table_rows and therefore shouldn’t add to the total. But, in my work, I haven’t run up to that limit using foreign IDs yet.

The recommended usage, at least for a single table, is to pull the entire hubdb table into a local variable and then operate on that, instead of calling back to hubdb repeatedly.