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
