Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Data Download
#5
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:

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
Reply


Messages In This Thread
Data Download - by NoSpark - 26.04.2017, 15:29
RE: Data Download - by jens - 27.04.2017, 09:42
RE: Data Download - by SuperQ - 27.04.2017, 10:56
RE: Data Download - by NoSpark - 27.04.2017, 20:08
RE: Data Download - by jens - 05.05.2017, 08:35

Forum Jump:


Users browsing this thread: 1 Guest(s)