为什么使用field比tag更快
Open
- Dominant language
- Java
- Stars
- 6.4k
- Forks
- 1.2k
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 115
Description
我使用in查询
10W个tag查询1000个条件的所有内容耗时70秒
10W个field查询1000个条件耗时4秒?
为什么,我应该把设备id改成field吗
Contributor guide
Research direction
The issue gives only a performance comparison between IN queries on tags and fields, using 100,000 items and 1,000 conditions; it names no source files or tests. Start by reproducing both measurements and then trace the query paths for tag and field filtering. Done means explaining the timing difference and whether using the device ID as a field is appropriate.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases, performance
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100