[OGo-Users] Speed after Backup-Recovery

[Christian Naumer]

users@opengroupware.org wrote: 
>
> 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;
Ok. Here is our output from these commands:


OGo=# SELECT COUNT(*) FROM object_acl;
 count 
-------
  3654
(1 Zeile)

OGo=# SELECT COUNT(*) FROM company;
 count 
-------
  1958
(1 Zeile)

> 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).
I'll dig in some more here and report then.

Thanks