[OGo-Users] Speed after Backup-Recovery

[Adam Tauno Williams]

--=-9e9OvLrycHt7zx6MCxqM
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> > That obviously depends on the amount of data you have in the DB. In =20
> > "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=3D# SELECT COUNT(*) FROM object_acl;
>  count=20
> -------
>   3654
> (1 Zeile)
>=20
> OGo=3D# SELECT COUNT(*) FROM company;
>  count=20
> -------
>   1958
> (1 Zeile)

Tiny!  No way the ACLs are causing that much of a performance issue.  We
have ~80,000 contacts each with *at least* two ACL entries, and
performance in extremely fast and load quite low.

> > Something which can make things slow is an obj_info table which is =20
> > not filled. Or missing indices.
> > Hard to say. To narrow the issue down, you can use -PGDebugEnabled =20
> > YES and:
> >    http://www.opengroupware.org/en/devs/docs/snippets/Profiling.html
> > (especially LSProfileCommands).
> I'll dig in some more here and report then.

I've also covered some of this stuff in WMOGAG.


--=-9e9OvLrycHt7zx6MCxqM
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBGcqp5LRePpNle04MRAknVAJ9tDv+KU0L0b0YplQ8PpcESZGFOsACeIKXR
ToWem8lel9AT1YHwhkqTTpI=
=/wRo
-----END PGP SIGNATURE-----

--=-9e9OvLrycHt7zx6MCxqM--