Our needs are admittedly different than that of others so the changes I would make would be specific to our needs and would probably not benefit anyone else (example: we would never have an alias pointing to anything other than an ID in the user table leading me to want to remove 'not equal' <> checks for circular references).
I do understand the reasoning behind the implementation and that it is probably ideal for 99% of those that use it. Thanks, -K p.s. Looking forward to a stable release of 2.3.x so we can compile against gmime 2.4! -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul J Stevens Sent: Tuesday, December 14, 2010 12:28 AM To: DBMail mailinglist Subject: Re: [Dbmail] Question: Configurable SQL statements On 2010-12-14 01:30, Kris Oye wrote: > Will a future release allow statements to be supplied via configuration > file? With an alias table of 750K+ entries this statement can get > expensive and I would rather rely on the DB collation and not use > lower() at all. While being able to override queries in a configuration file may be a neat feature for some, there are no specific plans to enable this. Personally I suspect such a feature would mostly be used by people to shoot themselves in the foot. It is so very easy to tweak things for higher performance, unwittingly breaking a couple of corner cases in the RFC's that will have your users call for blood. If you have performance issues with specific code-paths and queries, please suggest or provide a patch. Serious performance bottlenecks in the queries that can be fixed with better queries should be filed as bugs in the tracker. In this particular case, you might also consider using LDAP for storing user and delivery data. This will alleviate pressure on the relational database. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
