locationtech / geowave

GeoWave provides geospatial and temporal indexing on top of Accumulo, HBase, BigTable, Cassandra, Kudu, Redis, RocksDB, and DynamoDB.
Apache License 2.0
498 stars 190 forks source link

How to improve query performance? #1907

Open parselife opened 1 year ago

parselife commented 1 year ago

The type of Key/Value Store is RocksDB

There are about 800 thousand features in my type , when execute a cql query, it spent about 2min, how can i improve this? the query code snippt like :

       VectorQueryBuilder queryBuilder = VectorQueryBuilder.newBuilder();
        queryBuilder.addTypeName("xxType");
        queryBuilder.constraints(queryBuilder.constraintsFactory().cqlConstraints(cqlExpression));
        Query<SimpleFeature> query = queryBuilder.build();
        try (CloseableIterator<SimpleFeature> iterator = dataStore.query(query)) {
            while (iterator.hasNext()) {
                features.add(iterator.next());
            }
        }

Anyone can help me? Thx