Holy smokes...
There're no indices on that table at all. That's really really bad (and
it's my bad too).
I believe these are what you need:
create index up_websiteid_idx on roller_user_permissions(website_id);
create index up_userid_idx on roller_user_permissions(user_id);
create index up_pending_idx on roller_user_permissions(pending);
But if you've already figured out the indices you need, please send
them along so we can make sure they get into the release createdb and
migration scripts.
- Dave
On Nov 16, 2005, at 2:58 PM, Matthew Schmidt wrote:
Hi guys. Somehow, my database doesn't have any indices on
roller_user_permissions. This is causing queries to return much much
more than it should. The 1.3 to 2.0 indices don't appear to include
that table. Any ideas?
-Matt
Allen Gilliland wrote:
sounds good to me.
-- Allen
On Tue, 2005-11-15 at 12:14, Henri Yandell wrote:
So the email from Noel basically states that we can release at the
ASF.
My personal view is that we should ship 1.3 asap on java.net as
planned; and then 2.0 asap in a week or few on apache.org. It's a
nice
separation of 1.x at java.net and 2.x at Apache; and reduces the
chance of 1.3 being held up any longer when we really just want to
charge on with the Roller of the future and not be in this dual
branch state.
I advise that we do not mention the 1.3 release on any form of
*.apache.org website or mail it to one of the announce mailing lists.
Hen
