You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
During paranet sync process node execute a lot of queries like this (see below).
I've added index below and it helped to reduce time for these SELECT to complete, as well as resource consumption a bit. ALTER TABLE get_response ADD INDEX idx_operation_id (operation_id ASC);
SELECT status, keyword
FROM get_response AS get_response
WHERE get_response.operation_id = 'ca68e1c5-63e0-4027-a4da-4585dffe62bd'
The text was updated successfully, but these errors were encountered:
botnumberseven
changed the title
minor optimization for get_responsetable, operation_idindex
minor optimization for get_response table, operation_id index
Oct 28, 2024
During paranet sync process node execute a lot of queries like this (see below).
I've added index below and it helped to reduce time for these SELECT to complete, as well as resource consumption a bit.
ALTER TABLE get_response ADD INDEX idx_operation_id (operation_id ASC);
SELECT status, keyword
FROM get_response AS get_response
WHERE get_response.operation_id = 'ca68e1c5-63e0-4027-a4da-4585dffe62bd'
The text was updated successfully, but these errors were encountered: