In message "[exim] exim snapshot with sqlite on openbsd ..."
on 05.08.2005, jonathan vanasco <jvanasco@???> writes:
jv> for stats tracking, this is just a preference, but i'd be more
jv> inclined to use a faster db or format for writing -- sqlite is kinda
jv> slow for that stuff
SQLITE_AUTORESP_CHK = \
Select count(arp_aid) \
from autoresponder, user, domain, site \
where \
dom_name = '${quote_sqlite:$domain}' and \
dom_sit_aid = sit_aid and \
sit_aid = usr_sit_aid and \
usr_uname = '${quote_sqlite:$local_part}' and \
( ( arp_from = '0000-00-00' or arp_from <=
current_timestamp ) and ( arp_till = '0000-00-00' or
arp_till >= current_timestamp ) ) and \
arp_usr_aid = usr_aid and \
arp_status > 0
But :) you can add quite neat features in a normalized
db like many domains in one site with many users in a
site who have autoresponder with a from / till time.
Maybe slower but really great.
-
Karl-Heinz
