Re: Postgres: poor performance...
Marco Gaiarin <[email protected]>
| Newsgroups | gmane.comp.web.phpgroupware.general |
|---|---|
| Organization | La Nostra Famiglia - Polo FVG |
| Message-ID | <[email protected]> |
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