search

jdbc-json / jdbc-cb

A JDBC driver for Couchbase, using the N1QL query language.
Apache License 2.0
16 stars 12 forks source link

Possible Performance issue: Jdbc-json driver is taking longer time to run the queries when compared to Query workbench/cbq #31

Open suravarjjala opened 8 years ago

suravarjjala commented 8 years ago

Here is the query I am running from Query workbench:

select sum(totalCount) as Total, component, build, sum(failCount) as Failures,(sum(failCount)/sum(totalCount))*100 as Perc from server where build = "4.5.0-1733" and os = "CENTOS"

group by component , build

having (sum(failCount)/sum(totalCount))*100 > 2

Time taken: 6 sec - 7 sec

If I run the same query from Netbeans via Jdbc-json driver

It takes: 12 sec - 15 sec