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/