Skip to content
  • Join Us
  • Insights
  • Events
  • Contact
  • Join Us
  • Insights
  • Events
  • Contact
Sinara_Pos_DIGITAL
  • Sectors
    • Start Ups
    • Exchanges
    • Brokers
  • SinaraTLC
    • TLC Exchange
    • TLC Broker
  • Managed Services & Support
  • Consulting
  • Why Sinara?
    • Our Story
    • Meet the Team
    • Specialist Areas
    • Our Approach
    • Press Releases
  • Sectors
    • Start Ups
    • Exchanges
    • Brokers
  • SinaraTLC
    • TLC Exchange
    • TLC Broker
  • Managed Services & Support
  • Consulting
  • Why Sinara?
    • Our Story
    • Meet the Team
    • Specialist Areas
    • Our Approach
    • Press Releases
USE CASE

Overnight Payment System

Home » Use Cases » Overnight Payment System

Reduced processing time for peer-to-peer lender by 50%

Sinara was appointed to investigate a specific IT performance problem at a UK peer-to-peer lending company. A critical sub-system, the daily overnight Repayments process, was sometimes taking too long, causing an adverse impact on normal operations. Sinara carried out a technical analysis and recommended practical areas for improvement which resulted in reducing processing time by almost a half.

Sinara’s investigation comprised the following activities:

  • Review of historical SQL Server metrics, logs and query usage
  • Understanding and review of the database schema
  • Identification of key process database procedures
  • Examination of overnight diagnostics from the production environment
    Set up of a reproducible test environment
  • Detailed profiling and experimentation within the test environment

Sinara identified a number of areas for potential improvement and, importantly, were able to measure the effectiveness or otherwise of possible solutions. A report was produced detailing a number of practical and cost-effective recommendations for improving efficiency:

  • Slight restructuring of the Repayments process to improve performance by between one third and one half
  • Reconfiguration of the SQL Server database files
  • Archive and purging of unneeded historical data
  • Regular database index reorganisation
  • Rationalisation of database indexes

Related Use Cases

Transforming Non-Exchange Traded Metals with Cutting-Edge Trading Solutions

Digital warehouse receipt listing, management & trading A new international exchange wanted to introduce a modern B2B trading platform for non-exchange traded metals, enabling seamless

Read Use Case »

Automated Electronic Auctions for Commodities Exchange

Fully automated price auction management for platinum and palladium

Read Use Case »

Market Data Distribution for Commodities Exchange

Real time prices and quotes disseminated to exchange clients’ systems

Read Use Case »
Load More

Why the markets choose Sinara

  • 35 years’ experience across the trading lifecycle
  • Pre-built trading modules accelerate speed to market
  • Software expertise to customise complex integrations 
  • Everything is 100% supportable and sustainable

We are the trade engineering people.

Find out why

Ready for the next step?

Whether you have detailed requirements for your new business IT solution or wish to discuss your initial thoughts and ideas, contact us to see how Sinara can help.

Get Started
Linkedin Twitter
Sectors
  • Exchanges
  • Brokers
  • Start Ups
  • Exchanges
  • Brokers
  • Start Ups
Solutions
  • SinaraTLC
  • SinaraMDP
  • SinaraTLC
  • SinaraMDP
Resources
  • Insights
  • Use Cases
  • Specialist Areas
  • Insights
  • Use Cases
  • Specialist Areas
Culture
  • Why Sinara?
  • Meet the Team
  • Our Approach
  • Careers
  • Why Sinara?
  • Meet the Team
  • Our Approach
  • Careers

Privacy Policy © All Rights Reserved

© Sinara Consultants Ltd © 2025