SQL query audit_events, why so slow?
SELECT “AUDIT_EVENTS_ID”,“ACTION”,“ACTION_TARGET”,“ACTION_VALUE”,“ACTOR”,“EVENT_TIMESTAMP” FROM audit_events
The “LIMIT” option has no effect if Ignition can’t figure out how to insert the necessary clause (or misplaces it due to UNION or other odd clauses). And even if present, a query like yours may have to scan the entire table anyways, before it can apply the LIMIT.
Use a WHERE clause that includes columns that are indexed.
Yeah！I develop a new Page，first use sql bind limit 100 data.
But first reload still have about a little seconds later.
Let me repeat:
Use a WHERE clause that includes columns that are indexed.
1 Like