© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
I still don't see the actual SQL statements, but we do have two clues:
1) Repeated '4' values indicates that values are repeating
2) "displaying 10 of 1752600" indicates that there are a lot of values, which could explain the CPU time. This could conceivably tally with 2 minutes of CPU time.
I'm guessing the first query is returning way too many values. I will look at the code to see if I can get a hint. It would have been great if the SQL statements were there, but I'll see if I can just see the problem.