[OGo-Users] Speed after Backup-Recovery

[Helge Hess]

On Jun 15, 2007, at 08:24, Christian Naumer wrote:
> Could it be that using
> acl's is having this kind of impact? I think I read in the list that
> acl's make things slow. I didn't expect it to be this dramatic.

That obviously depends on the amount of data you have in the DB. In  
"regular" environments it shouldn't be an issue.

SELECT COUNT(*) FROM object_acl;
SELECT COUNT(*) FROM company;

Something which can make things slow is an obj_info table which is  
not filled. Or missing indices.
Hard to say. To narrow the issue down, you can use -PGDebugEnabled  
YES and:
   http://www.opengroupware.org/en/devs/docs/snippets/Profiling.html
(especially LSProfileCommands).

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