[OGo-Users] Speed after Backup-Recovery

Christian Naumer users@opengroupware.org
Sat, 30 Jun 2007 17:24:54 +0200


users@opengroupware.org wrote: 
> 
> As mentioned before you should also check that the obj_info table is  
> properly filled (pg-fill-objinfo.psql SQL script).
The table has 4200 rows. Is that reasonable?
> I think this table is used by object::get-by-globalid (the 52s thing).
Where do I find the script? Sorry total SQL newbie...

> 
> As mentioned by Adam 80s is extremely slow. I think something like 5s  
> should be the absolute maximum on a reasonably modern server.
> 
P4 2.8 G Dualcore with 4GB of Ram but RAID or anything.

Thanks for the useful answers I think we are getting there.

regards

Christian


-- 
Dr. Christian Naumer
Scientist Molecular Biology

B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail cn@brain-biotech.de, homepage www.brain-biotech.de
fon +49-6251-9331-30  /   fax +49-6251-9331-11

Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Dr. Holger Zinke (Vorsitz), Dr. Jrgen Eck
Vorsitzender des Aufsichtsrats: Ulrich Putsch