Ufff.... thanks Pierluigi, the velocity of execution of the query increase from 3 seconds to 0.1 seconds, you saved my day, excuse for my low basic SQL languaje expertise. Best Regars
Ufff thanks Pierluigi the velocity of execution of the query increase from 3 seconds to 0.1 seconds, you saved my day, excuse for my low basic SQL languaje expertise. Best Regars
Hello Pierluigi thanks for your help, please can you give some idea of how make a fast and efficient sql query to get the last event record on eventdata record of given deviceID vehicle, the columns of this table are: Best regards Nelson
Hello Pierluigi thanks for your help, please can you give some idea of how make a fast and efficient sql query to get the last event record on eventdata record of given deviceID vehicle, the columns of this table are: Best regards Nelson
Hello I use the following query to get last eventdata row in eventdata table: select * from gts.EventData where deviceID='don005' order by timestamp desc limit 1; but it slower and efficient query, i see that opengts gets faster this row, the answer is ¿ what is the query that use Opengts to retrieve last eventdata row for a deviceID vehicle??? Thanks Best Regards Nelson Rodriguez
Hello, can you tell me how to instal webDisk within a tomcat servlet container????...
Hello i have the same problem please help me with ubuntu: nelsonr@nelsonr:/usr/local/OpenGTS$...
what opengtsversion do you ripped the version of rulesfactoryexample??