With the Microsoft .NET Enterprise Servers, the solution can run more queries offline, rather than interactively. Reports that used to take weeks to produce now can be compiled in an hour. The solution uses SQL Server transactional replication, which allows it to expedite data flows by minimizing them only to information that is needed for processing. By minimizing the need to move data, the system can support faster, higher-volume transactions using replication and DTS processing. Scalability is enhanced when redundant or otherwise unnecessary data flows are minimized, further speeding the user experience.
Consumers also benefit from better data access, for example, with faster response times.
That's because FreeShop doesn't depend on a single, centralized database that could become bogged down during peak demand. For example, queries that in a large, centralized database system would take seven seconds on the back end can be processed on the Microsoft platform in less than a second. A single change in the central location changes the logic throughout the system, making it faster for us to deploy rule changes and to control rule changes for backward compatibility. The use of COM also makes it easy to expose the business logic to the OLAP structure. As a result, users can see how many items have been disposed of for violation of a business rule, then go back in to modify and correct the records.