Re: (imap) performance for list folders

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)

--===============1694861533==
Content-Type: multipart/signed; protocol="application/pgp-signature";
	boundary="=_2ca83a0dddb6e477ad385f172e685000"; micalg=pgp-sha256

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)

--=_2ca83a0dddb6e477ad385f172e685000
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII;
 format=flowed

Hi again.

I was just wondering if anyone is interested in trying to optimize this 
(possibly with Stored Procedures or maybe VIEWs) - unfortunately I am 
not really that familiar with the code in question to be able to do much 
here myself, but I could definitely help with the (PostgreSQL) DB side 
if someone wanted to try tackling this.

Regards,
   Thomas R

On 2018-03-16 11:29, Thomas Raschbacher wrote:
> hi.
> 
> has anyone experience with users with lots of folders, where
> retrieving the folder list takes 5-10 seconds (tested with just a
> python interactive prompt, so it really only does that)
> 
> the table has an index on the name, so the DB query should be
> relatively fast - so it seems the delay is somewhere in dbmail-imapd?
> 
> Regards
> 
> _______________________________________________
> DBmail mailing list
> [email protected]
> http://lists.nfg.nl/mailman/listinfo/dbmail


--=_2ca83a0dddb6e477ad385f172e685000
Content-Type: application/pgp-signature;
 name=signature.asc
Content-Disposition: attachment;
 filename=signature.asc;
 size=833
Content-Description: OpenPGP digital signature

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEWcgt91MG0ec5UGkFsqRChG75cVUFAlt2ZpMACgkQsqRChG75
cVWsKw//cTNdfdWZyZEye8spo8ESKCU+JynarWtRJkB36AtdTJWH61wbTnmQuoqp
/68X7sk2qCc6aXG4eY591bO4VBzRa+KirLQn/hPd/5E0Dh87HsNXZJEO9m4E5ngx
PPHglWSmE+ZdM0p9fLel/TOZ0Q6wTLeaTs13UbzKONYaBw4lNoVkhk/BpXiHMDyI
R9Q9c+yiupHWrR3W4AeWEp/fZr4ZV4UhkdK46R13OSn/ySu2TANjXtdXi6lsb4vS
DIsO6RLA7HzDmNt3q0HFZU1Rd/Yi2QN6I35cXVpd/STD4+X3Do219DATXLg1rF3v
9EXrpGdNHobZSF8uiL0xJDtQkb9mLHaLFBC7Llbbu/ivF27y2f4uR5Cjnt8DCiiy
10D9QAuVH5lLmA5922J3xlCvtmRKydFjFpuvArcJltgQ2AMd2dSNZxr4rJzzTLZj
KqL3viG7wnFZZd3k7iBYPSeC+L65dbuze9C3n7I/qBaeJc8mjKIBxboPY/YVjByy
6cRxQHNyrgMCYDKdeyobdib/1b0208ZH1ufA418Zd6WB6USv7/Y41T7R05lMu3kk
TYpwRwSc0nDWXOfMvbf3IEb+fEb+Rtfrbi52N6epkwTAkNgNqKfiAhll1vHM4IIo
ZIZipZY6Yyj5koru6ISaeg/o6A1zbqDLhpiuHNXy9CHP6k2lux0=
=aWv4
-----END PGP SIGNATURE-----

--=_2ca83a0dddb6e477ad385f172e685000--

--===============1694861533==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
DBmail mailing list
[email protected]
http://lists.nfg.nl/mailman/listinfo/dbmail

--===============1694861533==--