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! Dave Hall In chel di` si favelave... > It is a geenral problem with the addressbook. There was a script > floating around at some point to add the indexes to the contacts tables > for MySQL. I tried googling for it and couldn't find it. I know it > does really boost performance. I'm a bit astonished. For some really simple tasks (mass-modification of addresses, eg) assressbook are rather unusable. The only option are dump to paper or spreadsheet all the addresses and use the 'find' options to restrict addresses query, or limit the number of addresses to something big (100/200) and use 'open in new tab' to modify them. > Adding indexes to any field which is used in a where clause should help > performance. I know caching data is important and it is something we > should look at more in HEAD. Really all here use addresbook in this way? I doubt... -- 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