Re: [phpGroupWare-users] Postgres: poor performance...

[Marco Gaiarin]

Mandi! Benoit Hamet
  In chel di` si favelave...

> it could be the bottelneck. LDAP Is like another DB Engine, if you don't
> build indexes, you will drop performances ... take a look in the
> slapd.conf man pages, look for loglevel option, there's a level which
> trace index misses -> add them to your slapd.conf, rebuilt them using
> slapindex (IIRC), and you should be ok.

I completely confirm that.

It was sufficient to put 'loglevel none' insted of the default debian
'loglevel 0' that disable log completely.

I've got a bounch of:

        Sep 12 15:21:55 invernomuto slapd[8811]: <= bdb_equality_candidates: 
(phpgwAccountID) index_param failed (18) 
        Sep 12 15:21:55 invernomuto slapd[8811]: <= bdb_equality_candidates: 
(phpgwGroupID) index_param failed (18) 

and so i've added to slapd.conf:

        index phpgwAccountID    eq
        index phpgwGroupID      eq

and voilà, now phpgw fly...


Many thanks to all.

-- 
dott. Marco Gaiarin                                 GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it      tel +39-0434-842711  fax +39-0434-842797