Re:MySQL InnoDB Clustered Indexes and Rails (or How RescueTi...
by fuelfive on Tuesday March 11, 2008 @01:27AM
(#133943)
My startup has similar data volumes and reporting needs to rescuetime, and also runs rails on the backend. We found that traditional data warehousing techniques, and specifically running a MOLAP parallel to the SQL database, solved the performance problems so soundly that we could put 10x as many charts on a page and enabled data-slicing possibilities that were previously out of the question with the highly tuned SQL route. We were also able to get rid of all of the extra model code we had written to manage aggregations. See http://en.wikipedia.org/wiki/Online_analytical_processing for more background info if you're interested.
[ Parent
| on HN ]
Re:MySQL InnoDB Clustered Indexes and Rails (or How RescueTi...
by JoeH on Tuesday March 11, 2008 @02:28AM
(#133987)
I'd love to talk to you regarding your MOLAP implementation with RoR. I had previously taken a brief look at ActiveWarehouse as a potential solution, but put that on the back burner as we are currently in a very fast iterative development mode - having launched just a couple of months ago.
My last 16 years of database experience have been grounded in Oracle (oh Oracle 6 how I don't miss thee...) so I am fairly familiar with the the "Oracle" solution and storage of MOLAP cubes in Oracle Express, but am a complete noob when it comes to the OSS solutions. Any insight into your learning experiences would be most welcome!