This might be a bit odd, but here we go..
I have some data in a table that has the following structure:
CREATE TABLE `gaugereportinglist` (
`Updated` timestamp NOT NULL default
CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`StartTimeAndDate` datetime NOT NULL,
`Time_Offset` double default NULL,
`OutgoingPcntGgeDev` float default NULL,
`IncomingPcntGgeDev` float default NULL,
`MillSpeed` float default NULL,
`PassNumber` int(2) default NULL,
KEY `STADIndex` (`StartTimeAndDate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
The data is logged once a second. The StartTimeAndDate will be the same
for the particular workpiece that I am interested in.
I pull out the data with a select statement such as "select
`OutgoingPcntGgeDev` from gaugereportinglist where
`StartTimeAndDate`="2006-03-02 09:36:09" This can give me, say, 3 to 4
thousand rows. I am using BIRT (www.eclipse.org/birt) to do my
reporting. These value are shown on a graph. However 3000 points on a
small graph on a web page is a little over the top, and takes a long
time to plot. Is there any way to select say, every 10th point without
doing anything on the client side?
