Open Bucket slow connection

[jmorris]

@schuranator

Now I am using ClusterHelper in my global.asx but in my DataLayer I’m just using the following code not sure if this is correct:[/quote]

You should probably be using the defaults here unless your performance requirements show issues such as OperationTimeout’s. Just remove this from the config and the defaults will apply; otherwise make the max around 10 connections.

[quote=“schuranator, post:3, topic:6269”]
<connectionPool name=“custom” maxSize=“100” minSize=“5” sendTimeout=“2000” />[/quote]

If you are using ClusterHelper in your global.asax, why wouldn’t you being using it in your data layer? Just make your data layer classes implement a ctor that takes an IBucket reference and using ClusterHelper.GetBucket() to inject the dependency.

The problem with the code you have here is that the Cluster and Bucket will be created every time this code runs; what you want to do is create the Cluster and Bucket when the application starts and close/dispose when it ends. Using ClusterHelper helps here, read this: Couchbase SDKs

@schuranator

Also I’m noticing when I do a remove or insert lets say on Company if I’m using multiple buckets 98% of the time it doesn’t show that change unless I do a hard refresh. Is there something on my end I can do to make sure the changes have applied to all the nodes?

I not 100% sure I understand you here…buckets are shared across clusters. When you do write, the document is immediately available from the primary unless you are doing a replica read without durability constraints. That being said, for a N1QL query there is a small amount of time before the documents will be returned in the results because the value may not have yet been indexed. Read this post: N1QL - is there delay like a view query?

-Jeff