Data partioning to scale well

In most of the applications data keeps growing and application may become slow as the time passes when accessing data. There's a question always to scale data horizontally or vertically. Partitioning may be one option. Here is one of the good and interesting article.

Data partitioning

Popular posts from this blog

Generating unique string in C#

One of the solution in C# that generates unique string.  class UniqueString { private static readonly Random random = new Random(); private static readonly object syncLock = new object(); // Map to store 62 possible characters   private static readonly char[] charMap = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789".ToCharArray(); /// <summary> /// Generates unique string /// </summary> /// <param name="strLen">Length of the string.</param> /// <returns>Unique string of specified length.</returns> public static string GenerateUniqueString(int strLen) { if (strLen <= 0) { return null; } StringBuilder sb = new StringBuilder(); for (int i = 0; i < strLen; i++) { lock (syncLock) // synchronize { _ = sb.Append(charMap[random.Next(62)]); } } return sb.ToString(); } public static void Main() { // generate 10 character string Console...
Read more

Internet Information Services (IIS) on Load Balancer and shared folder for files

Image
In the load balancer setup for windows Internet Information Services (IIS) if shared folder is used for files to upload and download create virtual directory under application folder with alias as Upload(whatever you prefer) and physical path as \\sharedfilefolder\files$\AppFiles\ where files is the shared folder on sharedfilefolder and AppFiles is subfolder in the files folder Have the same setup on each server and the application works fine with upload and download of files from load balancer URL.
Read more

SQL Query Optimization

SQL query optimization is bare minimum  requirement when working with queries. Need to look for Indexes, Execution plan etc. Few links that help to understand query optimization. SQL Query Optimization    query-processing-architecture-guide optimize-query-performance-sql-server
Read more