Re: [PERFORM] Query RE: Optimising UUID Lookups

2015-03-21 Thread Roland Dunn
Hi Maxim, Thanks for the reply, v interesting. Do you speculate that the 10,000 rows would be randomly spread because of the uuid-type that we chose, namely the uuid-4 type? i.e. the completely random one? If we'd chosen the uuid-1 type (mac address+timestamp), rows would have been more regularly

Re: [PERFORM] Query RE: Optimising UUID Lookups

2015-03-21 Thread Maxim Boguk
On Sat, Mar 21, 2015 at 6:01 AM, Roland Dunn wrote: > Hi, > Wonder if anyone can help. > > Have a lookup table where the primary key is a native uuid type > (filled with uuid's of type 4), around 50m rows in size. > > Have a separate table, table A, similar size (around 50m rows). > Primary key i

Re: [PERFORM] Performance issues

2015-03-21 Thread Josh Krupka
The other approaches of fixing the estimates, cost params, etc are the right way of fixing it. *However* if you needed a quick fix for just this report and can't find a way of setting it in Jaspersoft for just the report (I don't think it will let you run multiple sql statements by default, maybe