Thank You Stephen,
I am using AdoOutputAdapter to store data into MySQL database then extracting that data into MATLAB using MySQL ODBC connector.
The following discussion, I used to setup AdoOutputAdapter.
https://gridbits.gridprotectionalliance.org/t/measurement-data-retrieval-with-sql/99
First I created TimeSeriesMeasurement in MySQL in openPDC database.
CREATE TABLE TimeSeriesMeasurement(
SignalID NCHAR(36) NOT NULL,
Timestamp VARCHAR(24) NOT NULL,
Value DOUBLE NOT NULL
);
Then I run the following commands in Command prompt.
mysql -uroot -p
USE openPDC
SELECT * FROM TimeSeriesMeasurement;
When I query for most recent row FROM TimeSeriesMeasurement table It takes more than 30 sec to give that data because the TimeSeriesMeasurement table is very big in size.
Is this possible to get the most recent data from TimeSeriesMeasurement table.