Does anyone know if the 5000 record limitation in the ad-hoc reporting module also applies to the downloaded data?
Analytics and reporting
thanks for that - do you know if there are any adverse implications for increasing the record limit to say 10,000?
I did try and check this and found that in most cases I was only getting 5000 records in the downloaded file, but I had a couple of queries involving unions which were returning 10000+ records so I was a little confused (I guess it's possible that the unions are seen as seperate queries?)
I know I'm a bit late to the party, but I had a site with 50k users and upped this limit, no problem...
... until I ran a large report - it wasn't the server that died, it was the browser. Running a full user report ran ok (~2.5 seconds) and it then proceeded to display the whole thing in an html table. Neither Firefox nor IE liked that and after about 45+ minutes of trying to render the 50k row table the browser would crash.
The (quick and simple) fix was to // the code that displays the report after running it - the CSV files were fine. A better solution would have been to apply the limit to the display code but I didn't need to go there
Just something to bear in mind, hope this helps if you're having any issues as your report grows.