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 type = ‘MailSource’ and messageId = $messageId and uniqueId = $uniqueId LIMIT 1”;
bool result = false;
var queryRequest = new QueryRequest()
.Statement(strSql)
.AddNamedParameter("$messageId", messageId)
.AddNamedParameter("$uniqueId", uniqueId)
.AdHoc(false);
using (Cluster cluster = new Cluster(couchbaseClients))
{
using (IBucket bucket = cluster.OpenBucket(Archive,ArchivePassword))
{
var query = bucket.Query<MailSource>(queryRequest);
result = (query.Rows.Count > 0);
}
}
return result;
-
/**Poco/
public class MailSource:IDisposable
{public MailSource() { FromAdrress = new Person(); ToAddress = new MailAddressSource(); ReplyToAddress = new MailAddressSource(); CC = new MailAddressSource(); Bcc = new MailAddressSource(); AttachmentList = new List<FileAttach>(); Folders = new List<string>(); Viewers = new List<Viewers>(); Headers = new Dictionary<string, string>(); } public string Type { get { return "MailSource"; } } public Dictionary<string,string> Headers { get; set; } public string Id {get; set;} public string MessageId { get; set; } public string UniqueId { get; set; } public string Subject {get; set;} public Person FromAdrress {get;set;} public MailAddressSource ToAddress {get; set;} public MailAddressSource ReplyToAddress {get; set;} public MailAddressSource CC { get; set; } public MailAddressSource Bcc { get; set; } public DateTime Date { get; set; } public string Body { get; set; } public string HtmlBody { get; set; } public bool IsBodyHtml { get; set; } public List<FileAttach> AttachmentList { get; set; } public List<string> Folders { get; set; } public DateTime MailArchiveDate { get; set; } public List<Viewers> Viewers { get; set; } public void Dispose() { GC.SuppressFinalize(this); }
}
3-Secundary Index****
CREATE INDEX Index_messageId_uniqueId ON archive(messageId
,uniqueId
) WHERE (type
= MailSource
) USING GSI
4App.Config*******