Comments for Fast UNION support now in InfiniDB at http://infinidb.org , comment 1 to 1 out of 1 comments http://infinidb.org Wed, 08 Sep 2010 16:31:49 +0100 FeedCreator 1.7.3 http://infinidb.org/infinidb-blog/fast-union-support-now-in-infinidb.html#comment-3 True. When working for Sun/MySQL I remember a gig where the first thing to do was converting UNION's to JOINs or other more efficient ways to store the data. (The UNION version of the query had been written for using Oracle as the database - another example how 2 databases can support the same standard SQL syntax, but performance can still make SQL from on product unusable on another.) Since storage engines normally don't even operate on this level of MySQL (a UNION is really just 2 separate queries :-) I guess this is a nice side benefit you get since you have to intercept the query anyway for the Calpont engine to work on it. - Henrik Ingo Sun, 29 Nov 2009 19:28:44 +0100