I have some doubt about N1ql

SQL++
5

Hey @geraldss,

I have a question for you.

I have a query so simple:

SELECT * FROM default WHERE actual = 30 

"status": "success",
    "metrics": {
        "elapsedTime": "428.056921ms",
        "executionTime": "427.883453ms",
        "resultCount": 4221,
        "resultSize": 1769869
    }

Explain plan:

cbq> explain select * from default where actual = 30;
{
    "requestID": "e9cb8173-4043-4596-b11d-9aca4d8d2053",
    "signature": "json",
    "results": [
        {
            "#operator": "Sequence",
            "~children": [
                {
                    "#operator": "IndexScan",
                    "index": "indextest",
                    "keyspace": "default",
                    "limit": 9.223372036854776e+18,
                    "namespace": "default",
                    "spans": [
                        {
                            "Range": {
                                "High": [
                                    "30"
                                ],
                                "Inclusion": 3,
                                "Low": [
                                    "30"
                                ]
                            },
                            "Seek": null
                        }
                    ],
                    "using": "gsi"
                },
                {
                    "#operator": "Parallel",
                    "~child": {
                        "#operator": "Sequence",
                        "~children": [
                            {
                                "#operator": "Fetch",
                                "keyspace": "default",
                                "namespace": "default"
                            },
                            {
                                "#operator": "Filter",
                                "condition": "((`default`.`actual`) = 30)"
                            },
                            {
                                "#operator": "InitialProject",
                                "result_terms": [
                                    {
                                        "star": true
                                    }
                                ]
                            },
                            {
                                "#operator": "FinalProject"
                            }
                        ]
                    }
                }
            ]
        }
    ],
    "status": "success",
    "metrics": {
        "elapsedTime": "2.506426ms",
        "executionTime": "2.295134ms",
        "resultCount": 1,
        "resultSize": 2009
    }

When I did using Elasticsearch.

"query": {
"bool": {
"must": [
{
"term": {
"couchbaseDocument.doc.actual": "30"
}
}
],
"must_not": [ ],
"should": [ ]
}
}

4221 hits. 0.054 seconds.

what is the advantage when I am using n1ql over elasticsearch? or they are different concept.

Elasticsearch always be more faster than n1ql or Am I wrong?

Regards.