Re: [PERFORM] Query limitations (size, number of UNIONs ...)

2005-06-03 Thread Stephen Frost
* Marc Mamin ([EMAIL PROTECTED]) wrote: > I've just made a first test wich resulted in a query being 15KB big annd > containing 63 UNION. If the data is distinct from each other or you don't mind duplicate records you might try using 'union all' instead of 'union'. Just a thought. Stephe

[PERFORM] Query limitations (size, number of UNIONs ...)

2005-06-02 Thread Marc Mamin
Hello, I've split my data in daily tables to keep them in an acceptable size. Now I have quite complex queries which may be very long if I need to query a large number of daily tables. I've just made a first test wich resulted in a query being 15KB big annd containing 63 UNION. The Query pla