Re: [Secureideas-base-devel] Optimizing maintenance query
Brought to you by:
secureideas,
sinukas
From: Randal T. R. <ra...@pr...> - 2008-08-20 12:42:22
|
On Mon, August 11, 2008 10:34 am, Michael Stone wrote: > On Mon, Aug 11, 2008 at 09:28:05AM -0500, Micah Gersten wrote: >> Let's see what Randal comes up with. I ran my query against a MyISAM >> DB. I'm going to try converting it to InnoDB and see what happens. I >> should get a speed increase. > > I predict a significant decrease, but I'm curious to see the actual > numbers. Just wanted to send an update to say sorry for the delay. Last week was terrible and I'm also just getting over a cold. Ick. Anyway, I hope to have some results posted by this weekend. I'm testing against MySQL (MyISAM/Innodb), Postgres and Oracle 11g. Any other requests? Thanks, Randy |