sureshanaparti commented on PR #8737:
URL: https://github.com/apache/cloudstack/pull/8737#issuecomment-1991877845

   
   > In case of a delete operation with some filter, before deleting the 
records database needs to fetch the records from the database. If the index is 
not present, this fetching of records from the database becomes slow and leads 
to scanning of all rows in the table resulting in high I/O on disk.
   
   thanks for sharing the results @vishesh92 , seems there is some improvement 
with the index.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to