Return-Path: Delivered-To: apmail-roller-user-archive@www.apache.org Received: (qmail 93290 invoked from network); 7 Mar 2008 16:57:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Mar 2008 16:57:03 -0000 Received: (qmail 56559 invoked by uid 500); 7 Mar 2008 16:56:57 -0000 Delivered-To: apmail-roller-user-archive@roller.apache.org Received: (qmail 56541 invoked by uid 500); 7 Mar 2008 16:56:57 -0000 Mailing-List: contact user-help@roller.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@roller.apache.org Delivered-To: mailing list user@roller.apache.org Received: (qmail 56483 invoked by uid 99); 7 Mar 2008 16:56:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Mar 2008 08:56:57 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [193.2.237.25] (HELO mail1.gov.si) (193.2.237.25) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 07 Mar 2008 16:56:11 +0000 Received: from smtp.gov.si (smtp1 [172.24.240.71]) by mail1.gov.si (MailServer) with ESMTP id 5A043281D1 for ; Fri, 7 Mar 2008 17:56:32 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp.gov.si (MailServer) with ESMTP id 4026C54008 for ; Fri, 7 Mar 2008 17:56:32 +0100 (CET) X-Virus-Scanned: amavisd-new at gov.si Received: from smtp.gov.si ([127.0.0.1]) by localhost (localhost.localdomain [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id bt0Lj3vCPPpT for ; Fri, 7 Mar 2008 17:56:32 +0100 (CET) Received: from hp-a180 (mail.mf-rs.si [192.168.220.40]) by smtp.gov.si (MailServer) with SMTP id 255C654003 for ; Fri, 7 Mar 2008 17:56:32 +0100 (CET) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: RE: Problem with database load Date: Fri, 7 Mar 2008 17:56:40 +0100 Message-ID: <401175E741D5334E8D846560862B5B6F02BEEA2E@mfrswdneecs01.mf.si> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Problem with database load Thread-Index: AciAaFidFimlh6swQBy6Ca5R06auJAAC1Nqg References: <20080307104107.167128738F@cal1-1.us4.outblaze.com> <401175E741D5334E8D846560862B5B6F02BEEA25@mfrswdneecs01.mf.si> <8fb9ac720803070730i512d6afemac2d24134d69a016@mail.gmail.com> From: =?iso-8859-2?Q?Boris_Miliki=E8?= To: X-Virus-Checked: Checked by ClamAV on apache.org 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]=20 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=E8 = 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