indexes, query limits, nested transactions