this pr moves the anti join for the bulk permission check from the python to sql, causing only the inaccessible IDs to be sent back over the network, instead of the accessible ids. In general, the inaccessible IDs should be a much smaller list than the accessible IDs, so this should further improve the efficiency of the bulk record check.
this pr moves the anti join for the bulk permission check from the python to sql, causing only the inaccessible IDs to be sent back over the network, instead of the accessible ids. In general, the inaccessible IDs should be a much smaller list than the accessible IDs, so this should further improve the efficiency of the bulk record check.