Querys problems last too long. Appreciate your help. I have a cube that begins at fast but then I have more than 100 documents attached becomes slow: Query Poco secondary index 4)App.Config**** /*Query/ string strSql = “select messageId,uniqueId from archive where typ…

In your CREATE INDEX statement, you need to change type = MailSource to type = ‘MailSource’ You need to drop all your indexes and re-create them with this correction.

Querys problems last too long

SQL++

jrtaveras July 18, 2016, 4:03pm 7

For this query should use the primary index , but for other queries should use secondary indexes , but the trouble is that no matter query run everything is slow.

Topic		Replies	Views
Query taking time with increase in no of documents. SQL++ query , n1ql , index	1	665	May 2, 2019
Query Optimization Help SQL++	1	494	May 30, 2020
N1QL Index and Sorting SQL++	2	814	February 13, 2019
Group Query is taking way to long SQL++	1	571	February 17, 2020
Query taking too long SQL++	1	677	November 28, 2019

Querys problems last too long

Related topics