batch indexing and connection pools