var http = require(“http”);
var Path = require(‘path’);
var Hapi = require(“hapi”);
var couchbase = require(‘couchbase’);
var myCluster = new couchbase.Cluster(‘couchbase://10.130.18.96:8091’);
var myBucket2 = myCluster.openBucket(‘adInfo’);
var myBucket3 = myCluster.openBucket(‘campInfo’);
var myQuery = couchbase.N1qlQuery;
var jsonData = {“Subject”: “Report a problem”, “Text”: “The worst updation” };
var myQuery = couchbase.N1qlQuery;
var getAll= null;
var response_from_first_filter = null;
var appName =“xyz”;
var Response=null;
var getAll = null;
var http = require(“http”);
var couchbase = require(‘couchbase’);
var myQuery=couchbase.N1qlQuery;
var responseFromFirstFilter = [];
var applicationName =“xyz”;
var responseFromDeepFilter = [];
var responseFromRankFilter = [];
var j=0;
var price=0;
var priceWeight = 1;
var rank = 0;
var moment = require(‘moment’);
var currentDate = moment().format(‘YYYY-MM-DD’);
var currentTime = moment().format(‘HH:mm’);
var genderFromForm= “male”;
var responseFromAdInfo = null;
var responseFromcampInfo = null;
var server = new Hapi.Server();
server.connection({ port: 8889 });
//Homepage
server.route({
method: ‘GET’,
path: ‘/’,
handler:
function (request, reply) {
reply.view(‘index’);
}
});
//Retreive all documents through N1QL
server.route({
method: ‘GET’,
path: ‘/retreive’,
handler:
function(request,reply){
getAll = myQuery.fromString('SELECT * FROM campInfo USE INDEX(appName USING GSI) WHERE appName= "'+applicationName+'"');
myBucket3.query(getAll, function(err, resp) {
if (err) {
console.log('Error', err);
}
// responseFromcampInfo=resp;
reply(resp);
});
}
});
//Starting the server
server.start(function () {
console.log(‘Server running at:’, server.info.uri);
});
I am using a simple getrequest using N1QL from couchbase server and the performance is very poor when the number of requests and connections increase.
What could be the problem? And are there any advantage of using views over N1QL?
I have tried using get
AB shows 5000 ms around with 10000 -n and 250 -c