roller-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Allen Gilliland <Allen.Gillil...@Sun.COM>
Subject Re: Problem with database load
Date Fri, 07 Mar 2008 17:03:47 GMT
Can you also provide explanations of why you think those indexes are 
necessary?  Having too many indexes on tables can actually make things 
worse, so you don't want to just flood the db with tons of indexes.

-- Allen


Boris Milikič wrote:
> 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