Hi Team,
Need your help on improving performance of N1ql.
which got impacted highly after I started using the 2.5.8 sdk.
Execuing N1ql thru Java after connecting to my bucket as below.
Connection to Couch:
Cluster cluster = CouchbaseCluster
.create(“xx.xxx:8091”);
Bucket secureBucket = cluster.openBucket(“userid”, “password”);
Exeuciton of N1ql:
String placeholders = “placeholders”;
JsonObject placeholder = JsonObject.create().put(“placeholders”,
placeholders);
String statement1 = “select a.* from ace_supplier a where a.type = $placeholders”;
N1qlQuery querytoextractplaceholders = N1qlQuery.parameterized(
statement1, placeholder);
placeholderslist = secureBucket.query(querytoextractplaceholders);