Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Profiles Query #491

Closed
homer7198 opened this issue Jun 3, 2016 · 1 comment
Closed

Profiles Query #491

homer7198 opened this issue Jun 3, 2016 · 1 comment
Labels
fixed in wip

Comments

@homer7198
Copy link

The profile query for the profile listing view takes an extremely long time. Processing this query takes an average of 10min and maxes all CPU usage. I'm guessing because my profiles table has 50,000 rows but only 30 unique types of profiles so the counts for each profile takes a ridiculous amount of processing.

profile_name, (select COUNT(DISTINCT serial_number) from profile p2 where profile.profile_name = p2.profile_name) AS num_profiles, payload_name, serial_number, GROUP_CONCAT(payload_data) as payload_data', '1 GROUP BY profile_name, payload_name, serial_number
@bochoven
Copy link
Contributor

bochoven commented Aug 1, 2016

Should be fixed with d11586e

@bochoven bochoven closed this as completed Sep 9, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
fixed in wip
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@bochoven @homer7198