pChart 2.x forum http://wiki.pchart.net/forum/ |
|
Limits to MySQL data? http://wiki.pchart.net/forum/viewtopic.php?f=1&t=2245 |
Page 1 of 1 |
Author: | otownd [ Tue Nov 15, 2011 10:49 pm ] |
Post subject: | Limits to MySQL data? |
Is there a certain limit to how much data pchart can handle? I'm pulling from a DB that has about 700k rows . Maybe someone can help this newb about and look over the code? Code: <?php /* CAT:Line chart */ /* pChart library inclusions */ include("../class/pData.class.php"); include("../class/pDraw.class.php"); include("../class/pImage.class.php"); /* Create and populate the pData object */ $myData = new pData(); /* Connect to the MySQL database */ $db = mysql_connect("localhost", "root", ""); mysql_select_db("pchart",$db); /* Build the query that will returns the data to graph */ $Requete = "SELECT * FROM `power_trend_circuit`"; $Result = mysql_query($Requete,$db); while($row = mysql_fetch_array($Result)) { /* Get the data from the query result */ $timestamp = $row["circuit"]; $data = $row["reading_value"]; } /* Save the data in the pData array */ $myData->addPoints($timestamp,"Timestamp"); $myData->addPoints($data,"Value"); /* Put the timestamp column on the abscissa axis */ $myData->setAbscissa("Timestamp"); /* Name this axis "Time" */ $myData->setXAxisName("Time"); /* Specify that this axis will display time values */ $myData->setXAxisDisplay(AXIS_FORMAT_TIME,"H:i"); /* First Y axis will be dedicated to the temperatures */ $myData->setAxisName(0,"Temperature"); $myData->setAxisUnit(0,"grC"); /* Create the pChart object */ $myPicture = new pImage(700,230,$myData); /* Turn of Antialiasing */ $myPicture->Antialias = FALSE; /* Add a border to the picture */ $myPicture->drawRectangle(0,0,699,229,array("R"=>0,"G"=>0,"B"=>0)); /* Write the chart title */ $myPicture->setFontProperties(array("FontName"=>"pchart/fonts/Forgotte.ttf","FontSize"=>11)); $myPicture->drawText(150,35,"Average temperature",array("FontSize"=>20,"Align"=>TEXT_ALIGN_BOTTOMM$ /* Set the default font */ $myPicture->setFontProperties(array("FontName"=>"pchart/fonts/pf_arma_five.ttf","FontSize$"=>6)); /* Define the chart area */ $myPicture->setGraphArea(60,40,650,200); /* Draw the scale */ $scaleSettings = array("XMargin"=>10,"YMargin"=>10,"Floating"=>TRUE,"GridR"=>200,"GridG"=>200,"GridB"=>200,"DrawSubTicks"=>TRUE,"CycleBackground"=>TRUE); $myPicture->drawScale($scaleSettings); /* Turn on Antialiasing */ $myPicture->Antialias = TRUE; /* Draw the line chart */ $myPicture->drawLineChart(); /* Write the chart legend */ $myPicture->drawLegend(540,20,array("Style"=>LEGEND_NOBORDER,"Mode"=>LEGEND_HORIZONTAL)); /* Render the picture (choose the best way) */ $myPicture->autoOutput("pchart/examples/pictures/example.drawLineChart.simple.png"); ?> |
Author: | otownd [ Tue Nov 15, 2011 11:05 pm ] |
Post subject: | Re: Limits to MySQL data? |
I should add that I get a missing img on my test.html. I've also corrected any typo mismatches in the code to reflect proper directory structure. |
Author: | rom [ Tue Dec 06, 2011 4:20 pm ] |
Post subject: | Re: Limits to MySQL data? |
Do you get a blank page or something? Most probably PHP complains about missing memory. Raising the memory limit in php.ini might help: memory_limit=64MB |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |