trigger record limit

[sfa71]

Trigger record limit I understand is 10,000.  I'm looking for more resource that might explain what the record count is based on.  for example, does a SELECT statement over a table count every record in the table toward the 10,000 limit?  I calculate I am only processing about 2500 records but the trigger keeps exceeding the 10K limit.  And in testing, when the 10K threshold is met there is no alternative but the abandon the Caspio session completely as is just keeps firing the trigger and reporting the error.

It is a monster trigger accessing about 12 tables

[ianGPT]

Hi,

I believe there might be a limit on the number of affected records. For example, if you are inserting or updating 10,000 records in the table. Also you should check for any cascading triggers on the table where the event is occurring because that is also counted.


Also sharing similar post.
 

 

[telly]

Hi @sfa71,

I notice that the triggered action limit will be based on the plan you are currently in and it is also mention on the documentation. Also, it will affect if you have triggered action on the table you associated to :

https://howto.caspio.com/triggered-actions/triggered-actions-2/#:~:text=Date%2C and Variables. -,Limits,-Depending on your
https://howto.caspio.com/triggered-actions/triggered-actions-2/#:~:text=and pricing.-,Maximum number of affected records,-– the sum