相同查询,一个全文检索,一个精确字段全文检索,查询时间相差很大
查询花费时间截图
表结构如下
这是什么原因导致的呢,
The first query may have waited for disk I/O, the second one could be faster because it used cache. Run them a few times to make sure the difference is consistent.
我没有使用缓存啊,与缓存无关,第一个没有指定字段,第二个指定字段了
If you can consistently reproduce this, feel free to create an issue on github about this and share your table files, so we can reproduce it locally and investigate.