On Nov 30, 2007 9:47 AM, Bill Moran <wmoran@potentialtech.com> wrote:
I expect that the right way to make Drupal _truly_ database neutral is to have database-dependent and database-independent code. You'd only see this kind of thing at the lower levels, and higher logic code shouldn't even care about it.
The alternatives are: 1. Calling modules would do 'case' statements for each type of database. No one wants that, unless it is a highly optimized site with lots of customization ( i.e. not the normal Drupal core). 2. Use the lowest common denominator for SQL and live with performance and scalability issues. 3. Do database specific stuff (including optimization) in the abstraction layer (this is what Bill Moran advocates above). I am for #3 as the way forward. -- Khalid M. Baheyeldin 2bits.com http://2bits.com Drupal optimization, development, customization and consulting.