Re: Maximun number of unions in a single query

BigBoote66_at_hotmail.com wrote:

> In the spirit of adding some useful information to this thread for
> posterity:

Supplying a credit card number will score you a lot more points.

> I ran a quick test using your example (many simple inserts vs. one
> insert with many union alls) against our test server, using 5000
> inserts. The single statement, union all version took about 3 times
> longer than the 5000 individual inserts (44 seconds vs. 16 seconds) .
> What did this tell us?

My results differ. Can you post your test case?

Also 5000 inserts taking 16 seconds seem to be excessively slow... unless this is a very busy of very old Sun platform? Or am I spoiled with HP and Sun/AMD hardware? :-)

--
Billy