Paul J Stevens wrote:
Hi all,
I'm looking to optimize _ic_search without resorting to drastics.
I noticed dbmsgbuf.c retrieves the full message from the database in two
functions. In both cases first the physmessage_id is queried using the
msgid, followed by a query on the messageblks table using the
physmessage_id. Two queries where one suffices. A simple but effective
improvement I think. Query syntax (left join ... using ...) checked on
mysql/postgres (dunno about oracle or ansi-sql).
I also fixed some of the FIXME's ...
Ilja?
Looks good. I'v committed the patch.
PS. Of course searching still sucks major :-( until we get some real
header caching...
true..
Ilja
