Query is fast in couchbase query window but slow in C# code

[mreiche]

@justinlloyd

Also, count(meta(mybucket).id) took the same amount of time as pulling the results.

That tells me the query is executing slower, not the SDK processing results.

@justinlloyd

If I run Query B. It also takes 30ms in the Query window.
However, in the C# code, it takes 900ms.

That tells me the query executed in the SDK is not the same as the query executed in the UI.

Can you run the query in the ui and in C# and then run this query to see the timing?

SELECT * from system:completed_requests order by requestTime desc limit 2