Skip to content
This repository has been archived by the owner on Nov 13, 2018. It is now read-only.

ip_allow.config too slow to generate #1196

Closed
mtorluemke opened this issue Mar 22, 2016 · 0 comments · Fixed by #1199
Closed

ip_allow.config too slow to generate #1196

mtorluemke opened this issue Mar 22, 2016 · 0 comments · Fixed by #1199

Comments

@mtorluemke
Copy link
Contributor

export DBIC_TRACE=1 and the query that needs tuned shows up easily. Truncated output:

SELECT me.id, me.name, me.description, me.use_in_table, me.last_updated FROM type me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.short_name, me.latitude, me.longitude, me.parent_cachegroup_id, me.secondary_parent_cachegroup_id, me.type, me.last_updated FROM cachegroup me WHERE ( me.id = ? ): '11'
SELECT me.id, me.name, me.description, me.use_in_table, me.last_updated FROM type me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.short_name, me.latitude, me.longitude, me.parent_cachegroup_id, me.secondary_parent_cachegroup_id, me.type, me.last_updated FROM cachegroup me WHERE ( me.id = ? ): '11'
SELECT me.id, me.name, me.description, me.use_in_table, me.last_updated FROM type me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.short_name, me.latitude, me.longitude, me.parent_cachegroup_id, me.secondary_parent_cachegroup_id, me.type, me.last_updated FROM cachegroup me WHERE ( me.id = ? ): '11'
SELECT me.id, me.name, me.description, me.use_in_table, me.last_updated FROM type me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.short_name, me.latitude, me.longitude, me.parent_cachegroup_id, me.secondary_parent_cachegroup_id, me.type, me.last_updated FROM cachegroup me WHERE ( me.id = ? ): '11'
SELECT me.id, me.name, me.description, me.use_in_table, me.last_updated FROM type me WHERE ( me.id = ? ): '1'
SELECT me.id, me.name, me.short_name, me.latitude, me.longitude, me.parent_cachegroup_id, me.secondary_parent_cachegroup_id, me.type, me.last_updated FROM cachegroup me WHERE ( me.id = ? ): '11'

elsloo added a commit to elsloo/traffic_control that referenced this issue Mar 22, 2016
elsloo added a commit to elsloo/traffic_control that referenced this issue Mar 22, 2016
@elsloo elsloo added this to the 1.4.2 milestone Mar 22, 2016
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants