Tag Archive for Business Intelligence

MySQL client ran out of memory

December 31, 2009 Business Intelligence, Development No comments

I have been test­ing a num­ber of BI visu­al­iza­tion tools lately, and to do this I decided to use a set of Click­stream data that I have, which is approx­i­mately 6,500,000 rows. When I began load­ing the data into whichever tool I was test­ing I got an error that said “MySQL client ran out of mem­ory”. I am using the MySQL 5.1 ODBC Dri­ver. My con­nec­tion looks as fol­lows.
MySQL Connection
Ini­tially I checked the “Allow big result sets” in the con­nec­tion, how­ever this did not do any­thing. The only solu­tions that worked was to add the “Option=1048576″ to my con­nec­tion string.

Open Source BI

February 10, 2009 Business Intelligence, Open Source No comments

For a long while now I have been of the opin­ion that open source busi­ness intel­li­gence is reach­ing crit­i­cal mass. The soft­ware is get­ting a lot bet­ter, and peo­ple look for viable solu­tions to replace the often expen­sive pro­pri­etary offerings.

It was very encour­ag­ing for me to read Chris Webb’s blog where he expressed very much the same opin­ion.

With the worlds econ­omy as it is I believe it is only a mat­ter of time before open source BI gets the recog­ni­tion it deserves.