05.05.2017, 08:35
Hello NoSpark,
until now, the SmartPi did not create an index over date when the datatable was created. In the Github repository it is already fixed. This will be improved with version 0.5.9.
All newly created tables get the index. This means that the table in the next month will be created with index.
For the already created tables you could create the index by yourself:
smartpi_logdata_201705 is the name of the corresponding table and is the same as the database in /var/smartpi /db/.
Best regards Jens
until now, the SmartPi did not create an index over date when the datatable was created. In the Github repository it is already fixed. This will be improved with version 0.5.9.
All newly created tables get the index. This means that the table in the next month will be created with index.
For the already created tables you could create the index by yourself:
Code:
CREATE INDEX IF NOT EXISTS `dateindex` ON` smartpi_logdata_201705` (`date` ASC)
smartpi_logdata_201705 is the name of the corresponding table and is the same as the database in /var/smartpi /db/.
Best regards Jens