DaanHoogland commented on code in PR #7028:
URL: https://github.com/apache/cloudstack/pull/7028#discussion_r1058899233


##########
engine/schema/src/main/resources/META-INF/db/schema-41720to41800.sql:
##########
@@ -869,3 +869,6 @@ WHERE   usage_unit = 'Policy-Month';
 
 -- delete configuration task.cleanup.retry.interval #6910
 DELETE FROM `cloud`.`configuration` WHERE name='task.cleanup.retry.interval';
+
+--- #6888 add index to speed up querying IPs in the network-tab
+CALL 
`cloud`.`IDEMPOTENT_CREATE_UNIQUE_INDEX`('uk_user_ip_address_state','user_ip_address',
 '(state)');

Review Comment:
   :face_with_spiral_eyes: right, it shouldn´t be unique. I start over really 
thinking this through a bit.



-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to