I just found one more missing: create index ws_posttime_idx on roller_comment (posttime);
Next weekend I will walk through sql log and dbcreate.sql script and record in JIRA if I find something. Boris -----Original Message----- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2008 4:31 PM To: [email protected] Subject: Re: Problem with database load On Fri, Mar 7, 2008 at 10:15 AM, Boris Milikič <[EMAIL PROTECTED]> wrote: > Did you created missing indexes in rollerdb (4.0): > > create index ws_bloggercatid_idx on website(bloggercatid); > create index ws_defaultcatid_idx on website(defaultcatid ); Thanks Boris, I just opened an issue for this: https://issues.apache.org/roller/browse/ROL-1687 Are there any other 4.0 database issues that you know of that are not on record in JIRA? - Dave
