Processing 12 million records with Adhoc View

0

Uploaded a video of processing 12 million records in MySQL with Adhoc View.

https://youtu.be/-xtB_w0520w

The lesson learned is that Adhoc View isn't an OLAP engine so don't design database for OLAP. The database need to be tuned for Adhoc View - that is, separate Adhoc View database from Reporting database.

BTW, I'm using Japanese version of JasperReports Server 6.1.0 and MySQL on a single i5 notebook with 16GB memory. There wasn't any need to use RedShift.

 

Will appreciate if you can provide me with information on how to further improve Adhoc View performance.

hozawa's picture
47137
Joined: Apr 24 2010 - 4:31pm
Last seen: 2 months 2 weeks ago

0 Answers:

No answers yet
Feedback