On Thu, May 14, 2009 at 5:35 PM, Karun Dambiec karun@fastmail.fm wrote:
In terms of performance, it could possibly be better to write queries for each database type. ... An option could be to abstract the queries more for each database type, and not need to use the same query for MySQL, PostGreSQL and Oracle. That way the optimum query for each database type could be used to retrieve the information.
In most cases this is unnecessary. If cases arise where it's necessary, they can be dealt with then. It's entirely possible to check the class of the database object and run different queries based on that, if desired. We rarely have to do it.