[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