[How to improve drill through view performance?]

When we have around 5 million records and we try and filter and view about 50000 for that 5 million , the performance is very slow , about 15minutes till we can actually view the drilled through report , we using oracle , any ideas on what we can do to increase performance ?

[How to disable order by in jasper server olap functionality?]

we have alot of data , therefore we need to try and make the performance better , it seems like when we drill through , the query generated to be executed contains all these uneeded order by statements , this is making the query very slow , is there a way to totally disable this or atleast overide this so i can only do an order by maybe on one thing rather than everything like what it is doing now which is pointless?

[JasperReports Server 4.7.0 connect with JasperMobile App for Android]

why doesnt jasper mobile run on eclipse, all android plug ins were loaded