Changing how we transmit data to the Real Estate Franchises

The Challenge: Heavy Workload on Production Servers

Real estate franchises require comprehensive data from our clients, including:

• Listings: Properties actively on the market.
• Pendings: Properties under contract.
• Closings: Recently sold properties.
• Agent Information: Person profile, professional accreditations, team stats, and more.

This process requires several resource-intensive steps:

1. Data Collection: Gathering information from various tables in our database.
2. Formatting: Transforming the raw data into the required format for each franchise.
3. Transmission: Sending the formatted data to the franchises, multiple times daily and on-demand.
    

Impact on the Production Server:

• This workload places a heavy burden on the darwin.Cloud Production SQL server, which also handles critical day-to-day operations like user queries, data updates, and real-time transactions.
• As the volume of data and frequency of transmissions grow, this additional workload can slow down performance for all users.

The Solution: Offloading Workload to SQL Replicas

To address this challenge, we're redesigning the way darwin.Cloud handles franchise data transmission. Instead of performing these tasks directly on the production server, we’re moving the workload to the SQL Always On Replicas.

Here’s how it works:

1. Read Operations on SQL Replicas:
   • All data required for franchise summaries (listings, pendings, closings, agent stats) will be read from the SQL replicas, not the production server.
2. Offloading Formatting and Transmission:
   • The processing required to format and send the data will also be handled separately, on dedicated hardware,  away from the darwin.Cloud Production SQL server.

Why This Makes darwin.Cloud Faster

1. Reduced Load on the Production Server:
   • By moving all read-heavy operations to the SQL replicas, the darwin.Cloud production server is free to focus on critical real-time tasks like user interactions and data updates.
2. Optimized Resource Utilization:
   • SQL replicas are specifically designed for read operations, ensuring that data retrieval is efficient and does not interfere with write-intensive tasks on the production server.
3. Improved System Performance:
   • With fewer competing tasks, the production server can process user requests more quickly, resulting in a faster and smoother experience for everyone.
4. Scalability:
   • As the number of franchises submissions and the volume of data grow, SQL replicas provide the capacity to handle increased workloads without slowing down the system.

How This Benefits You

This optimization offers several key advantages for our users:

1. Faster Application Performance:
   • By reducing the workload on the production server, darwin.Cloud can now handle user queries and operations more quickly and efficiently.
2. Reliable Data Transmission:
   • Franchise data summaries will continue to be accurate and timely, processed by the SQL replicas with dedicated resources.
3. Future-Proof Design:
   • As your business grows and data transmission needs increase, this architecture ensures darwin.Cloud remains scalable and efficient.

Commitment to Innovation

At darwin.Cloud, we understand that our clients rely on us to manage complex operations with precision and speed. By offloading franchise data transmission to SQL replicas, we're taking another step toward delivering a faster, more reliable application. This change reflects our commitment to innovation, ensuring that darwin.Cloud continues to set the standard for real estate software performance.

We’re excited to bring this enhancement to you and look forward to seeing the positive impact it will have on your operations. Thank you for trusting darwin.Cloud to support your business needs!