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:[email protected]] Sent: 31 May 2012 18:28 To: [email protected] Subject: Re: API usage records and SQL On Thu, May 31, 2012 at 1:20 PM, Tamas Monos <[email protected]> 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
