geowave icon indicating copy to clipboard operation
geowave copied to clipboard

How to improve query performance?

Open parselife opened this issue 1 year ago • 0 comments

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

parselife avatar Oct 21 '22 09:10 parselife