Arjun Sunil Kumar
Arjun Sunil Kumar
### EXPLAIN with SELECT instead of INSERT ```sql mysql> explain analyze select `__mo_index_tbl_join_centroids`.`__mo_index_centroid_version` , `__mo_index_tbl_join_centroids`.`__mo_index_joined_centroid_id` , `__mo_index_tbl_join_centroids`.`__mo_org_tbl_pk_may_serial_col` , `t5`.`b` from (select `t5`.`a` as `__mo_org_tbl_pk_may_serial_col`, `t5`.`b` from `a`.`t5`) as `t5` inner...
GIST 960 takes `3 minutes and 15 seconds` to build. Add the below configs to `cn.toml` ```toml [[fileservice]] name = "SHARED" backend = "DISK" data-dir = "mo-data/shared" [fileservice.cache] memory-capacity =...
Currently tracked in https://github.com/matrixorigin/matrixone/issues/14610 . Will update this issue once the provided issue is resolved.
1. For KNN QPS: //OK Waiting for this issue to be resolved: https://github.com/matrixorigin/matrixone/issues/15196 Once that is fixed, we should get around 50-60 QPS for SIFT128 2. Create Index duration //...
KNN can be improved after solving this: https://github.com/matrixorigin/matrixone/issues/15572 Create Index is improved after merging this: https://github.com/matrixorigin/matrixone/pull/15573
> Note: Please take the latest pull of https://github.com/arjunsk/mo-benchmark-test/tree/master_index 1. SIFT 128 dataset - With PK | Load (1million) without INDEX | 30sec | | ------------------------------- | ----------- | |...
Hi @heni02 , most of the optimizations have been added to the master. Kindly verify the performance change.
As suggested by @fengttt , one approach is to support `EXPLAIN FORMAT=JSON select * from t3;`. Then query the JSON string to do JSON path etc to see if `BlockFilter`...