Large sitemap

3 min read We built a social network-type site recently with quite a large number of public-facing pages, and like any good site, we created a sitemap with links to every page. All fine on launch, every page we tested finished in under 3ms of logic processing, and everyone was very happy. A few weeks pass and everything looks great, until all of a sudden all our request times go through the roof, and the database is maxing out and we’re scratching our heads at what’s causing all the load. No abnormal requests,…

READ MORE

RavenDB Optional Queries and Boosting

< 1 min read After implementing query-time boosting, I found that I wasn’t getting the results I was expecting … or any at all. I discovered there was an overload when adding queries that tells the query whether it “must,” “must not,” or “should” occur in the results. Inside a query object that inherits from QueryBase, do the following:
Optional Queries

// "query" creation elided
// ...
this.AddQuery(query, BooleanClause.Occur.SHOULD);
return this;

This made the query optional, allowing the other matching results to be returned. But, since it’s boosted, if results are found matching this query, it will be boosted higher in the results. Problem solved.
Index-time boost

var doc = new Document();
// Code to add fields elided
// Set the boost
doc.SetBoost(boostValue);
READ MORE

RavenDB "In" operation

< 1 min read RavenDB supports an “in” operator, although vaguely documented.
First, include the namespace

using Raven.Client.Linq;

Usage

var ids = new[] { "myobjects/1", "myobjects/2" };
session
  .Query()
  .Where(o => o.Id.In(ids));
READ MORE

RavenDB Load Balancing

< 1 min read Somewhat counter-intuitive, this behavior is set at the client level, not the server. When servers are setup for replication, they create system documents of the other servers involved in replication. When the client accesses the primary server, it downloads and caches the replication information, so the client can “fail over” properly.
To set this up, you need to assign the FailoverBehavior convention in your DocumentStore.

READ MORE

RavenDB Lucene Query

< 1 min read How to build a Lucene query using extension methods, and not have the request go out until ToList() is called.

private List GetMembers(string nickname)
{
  var query = DocumentSession.Advanced.LuceneQuery(AllMembersIndex.Name);
  // Search for nickname
  if (!nickname.IsNullOrWhiteSpace())
    query = query.Search("Nickname", nickname);
  // Execute query
  return query.ToList();
}
READ MORE

RavenDB Create static index

2 min read

/// 
/// Gets the document store.
/// 
/// The document store.
///
/// Do this only once per AppDomain load. It's very expensive.
private static IDocumentStore GetDocumentStore()
{
    // Create the DocumentStore (expensive operation).
    IDocumentStore documentStore = new DocumentStore
    {
        ConnectionStringName = "RavenDB",
        Credentials = System.Net.CredentialCache.DefaultNetworkCredentials // For "trusted connections": see comments at http://ravendb.net/docs/client-api/connecting-to-a-ravendb-datastore
    };
    // Read from and write to all servers.
    documentStore.Conventions.FailoverBehavior = FailoverBehavior.ReadFromAllServers
        | FailoverBehavior.AllowReadsFromSecondariesAndWritesToSecondaries;
    // Initialize the store (must be done before creating indexes)
    documentStore = documentStore.Initialize();
    // Create static indexes
    CreateRavenStaticIndexes(documentStore);
    // Return document store
    return documentStore;
}
READ MORE

Categories

Tags

Active Directory ASP.NET Azure DevOps C# chocolatey cloudflare code quality csv-helper Debugging DevOps elasticsearch filezilla foreman git hashing HTML5 Image-Resizing InDesign interesting jquery Linq Localization lucene management md5 MS Office MVC neo4j PowerShell ravendb Razor reflection Release Notes REST RSS security Security Headers seo sonarqube SQL static code analysis TFS thread-management VSTS wordpress

Categories

Popular Posts

Observability using Elasticsearch and Neo4j
December 5
C# Active Directory
September 16
Process / Memory Dumps
September 21
Security Headers
October 1