dovecot - Feb 2010 - fts squat -> webmail, fastcgi timeout: SOLR the answer?

Hi

I turned on fts squat to speed up full text searches over webmail.
This works absolutely fantastic once the mailboxes are indexed.

But when they are indexed for the first time I'm getting a fastcgi timeout
after 30 seconds resulting into a internal server error on the webserver.
In the background the indexing job is getting finished after 80 seconds
for a 25k emails, ~300MB mailbox.

Does solr allow user-offline indexing (no user interaction needed to kick
on indexing) ?
And the other question is, is there any mail user agent that would support
server-side full text indexing and not create own indexes?

Thanks,
Philipp

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 10 Feb 2010, mailinglists at belfin.ch wrote:
> Does solr allow user-offline indexing (no user interaction needed to kick
> on indexing) ?
You can talk IMAP directly as user:

setuid user:group
export USER=user
export HOME=/home/path/user
/usr/sbin/dovecot --exec-mail imap

With system users you can do:

sudo -u user -H  /usr/sbin/dovecot --exec-mail imap

Then issue whatever IMAP command you like.

Regards,
- -- 
Steffen Kaiser
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQEVAwUBS3J7lr+Vh58GPL/cAQIsDgf+M+xP5FTz1P+ZNVYiDIdEYJHbv51ER7WQ
E529m9gVvJFsac77qIrj5FSTyJ0zxHAkYLYGaqKTKySJ6XKYUfq9HG/fmiTiRF1h
YmrvTsrrxgaI2oSeT6MUTwKpnZ/LrwJCLo5Ord79AzgEEEwaTMKGBTzIq+HvH4ru
hgX0HK47XMc05NM/IX9SnD0AdheC4q/v9u9xwvM199slLsxsB5wn0ZB1xhCaU/Vw
xsHMweeWFyUEDB5D7QvlUHfI6thMDCdVuIth/X8tYWef2eFNbSiiMsjBdqMwXF0d
ZuXjaCbfjpvNHjy6ZQzVLMQsBjx2OZA8F3MYZ94UhLz5Xo5sYcX8zA==vkHC
-----END PGP SIGNATURE-----

mailinglists at belfin.ch put forth on 2/10/2010 3:01 AM:
> And the other question is, is there any mail user agent that would support
> server-side full text indexing and not create own indexes?
Thunderbird.  Maybe all MUAs?  Usually with smartly designed MUAs body searches
are left to the IMAP server to perform.  On standard TB, in the absence of
about:config hacks, one cannot run a body search on an IMAP folder unless you
check the "Run search on server" box.  Anything else is a header
search, and
headers are already indexed by TB for pretty much everything.  TB doesn't
index
IMAP message bodies, _unless_ you have IMAP folders synchronized locally and are
running in offline mode.  In the offline case your search will utilize a local
index of message bodies.

-- 
Stan