Comments (4)
少し調べたんですが、1箇所でもビット演算子(&
とか)または算術演算子(+
とか)を使ってしまうと、全体で1つもインデックスを使わなくなってしまうようでした。
クエリーオプティマイザー(scan_info_build()
)ががんばらないといけないところなんですが、Cで書くのはツライので、mrubyを有効にしたときだけインデックスを使えるようになる、というのはありですかねぃ。。。
from groonga.
Rubyで書いてみたらCでも簡単に書けるやつだったのでmrubyなしでもがんばるようにしました。
で、たぶん、masterだと直っていると思うので確認してもらえませんか?
from groonga.
確認してみたところ,索引ありの状態で以下に示す結果となりました.
一つ目の &
を含むクエリでも索引が効いているようです.
検索結果にも問題ありません.
> select --table Data --filter 'between(Value, 0, "include", 100, "include") && ((Flag & 1) != 0)'
[[0,1415062629.88284,0.089080810546875],[[[10283],...
> select --table Data --filter 'between(Value, 0, "include", 100, "include")'
[[0,1415062633.69047,0.0181918144226074],[[[103719],...
> select --table Data --filter 'between(Value, 0, "include", 100, "include") && (Flag == 1)'
[[0,1415062636.64962,0.0799901485443115],[[[10283],...
Bravo!
from groonga.
よかったです!
from groonga.
Related Issues (20)
- Groonga 13.1.2
- Prepare to drop GNU Autotools: Survey impact on other projects
- Add a document for the common `n_workers` parameter
- Use inline instead of grn_inline
- Int64 is not supported for output_type=apache-arrow in columns that reference records in other table
- Groonga 14.0.0 HOT 18
- Proposal: Notify Developers with Error Message for Missing Submodules in CMakeLists.txt HOT 5
- Optimize CI jobs to run only necessary tasks HOT 1
- doc: Improve the i18n document in contribution guide
- Integrate the step to install depended libraries for building document into setup.sh
- Unify duplicated contents between i18n and introduction page in document contribution guide
- doc: add steps for updating documentation to document contribution page HOT 4
- Groonga 14.0.1 HOT 1
- Cannot build on FreeBSD 14.0 HOT 4
- ci: Introduce sphinx-lint
- Groonga 14.0.2 HOT 1
- docs: Recommend using `TokenNgram`
- Documentation Build Fails After Changing File Extension From `.rst` to `.md`
- groonga: add --default-n-workers
- NormalizerNFKC: add an option to remove diacritical mark
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from groonga.