roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Boris Milikič <boris.mili...@mf-rs.si>
Subject RE: Problem with database load
Date Fri, 07 Mar 2008 16:56:40 GMT
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:snoopdave@gmail.com] 
Sent: Friday, March 07, 2008 4:31 PM
To: user@roller.apache.org
Subject: Re: Problem with database load

On Fri, Mar 7, 2008 at 10:15 AM, Boris Milikič <boris.milikic@mf-rs.si> 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

Mime
View raw message