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

[DaveS]

My understanding is that the limit is only inserts and updates.  I've had a couple of cases where I mis-constructed an insert or update statement (especially inside a loop) where it was updating every record in the table instead of a single record, so that's something to look for in the WHERE clause of any update statements.

[cheonsa]

On 5/29/2024 at 10:31 AM, sfa71 said:

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

Hi @sfa71,

The affected number of records in Triggered Actions refers to the number of records met by the given condition. Let's say, in your Select Statement, 5 records satisfy the condition, then in another Select Statement, there are 10 records, the total number of affected records will be 15. Another count for inserting or updating the Table. 

Hope this helps.