I'm happy to file the bug and test it excessively but I doubt I can fix it as I'm more of a techie/tester. I came up with the array idea because that is how I fixed our DNS management platform when dealing with thousands of records, but that is php.
-----Original Message----- From: David Nalley [mailto:da...@gnsa.us] Sent: 31 May 2012 18:28 To: cloudstack-dev@incubator.apache.org Subject: Re: API usage records and SQL On Thu, May 31, 2012 at 1:20 PM, Tamas Monos <tam...@veber.co.uk> wrote: > Hi, > > Thank you for spotting this out. > I think it is worth filing a bug for fix/improvement. > Could we somehow build an array with those IDs and send the whole query at > once instead of calling separately for all records? > Bugs at http://bugs.cloudstack.org Think you could work up a patch that lowers the number of queries by a few orders of magnitude? --David
