[GitHub] [incubator-iotdb] kqkdChen opened a new issue #1425: SQL执行时间怎样优化到毫秒级别？还是说根本就不可能？

[GitBox]

kqkdChen opened a new issue #1425:
URL: https://github.com/apache/incubator-iotdb/issues/1425


   data count: **18999994** total
   SQL: **select * from root.position where time > 1559179819000 limit 10**
   执行上述sql：
   shell client显示花费时间： **6.171S**
   
![image](https://user-images.githubusercontent.com/41674301/85938068-3f560600-b93c-11ea-8d32-191462885398.png)
   
   IOTDB Metrics Server：**0-7ms??????????**
   
![image](https://user-images.githubusercontent.com/41674301/85938110-8217de00-b93c-11ea-9b86-6abbabbf30b1.png)
   
   为什么两者差别如此之大？
   我还尝试使用jdbc api，时间花费在5s，我以为查询会很强，没想到这么弱，感觉比不上HBase...
   
   
这是你们的产品介绍，我不知道是否是我的用法有问题，查询根本做不到毫秒级别，超过300W数据就已经是秒级别了，官网的文档也不详细，基本的性能调优我都没有找到。
   
![image](https://user-images.githubusercontent.com/41674301/85938135-cefbb480-b93c-11ea-8b00-8d58f4527686.png)
   
   求解惑，还有尽快完善文档吧，连集群模式都没有，生产谁敢用...
   


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org