[OGo-Users] Speed after Backup-Recovery

[Helge Hess]

On 29.06.2007, at 14:52, Adam Tauno Williams wrote:
>> Probably one for each entry. And then thsi one comes in:
>> 40.149s person::extended-search
>>   52.273s object::get-by-globalid
>>     0.003s userdefaults::get
>>     0.000s userdefaults::get
>>   5.749s person::get-extattrs
>>   7.460s person::get-telephones
>>   4.926s person::get-comment
>> 78.742s person::get-by-globalid
>> Anyone can compare these to other results?
>
> Don't need to,  those are REALLY REALLY slow.  Your PostgreSQL  
> database
> is either badly configured (see postgresql.conf) or you are missing
> all/some of the indexes.  I'd suspect your database restore didn't
> include these items.
>
> The problem is *NOT* in OpenGroupware, but in your database.

As mentioned before you should also check that the obj_info table is  
properly filled (pg-fill-objinfo.psql SQL script).
I think this table is used by object::get-by-globalid (the 52s thing).

As mentioned by Adam 80s is extremely slow. I think something like 5s  
should be the absolute maximum on a reasonably modern server.

Greets,
   Helge
-- 
Helge Hess
http://www.helgehess.eu/