Microsoft Download Center Archive

Optimization Guide for Mainframe App and Data recompiled to NET and SQL Server

  • Published:
  • Version: 1.0
  • Category: windows
  • Language: English

Optimization Guide for Mainframe App and Data recompiled to .NET and SQL Server

This guide offers optimization advice for executing point-lookups against SQL Server from .NET as efficiently as possible. Customers wishing to migrate from mainframe databases to SQL Server may desire to migrate existing mainframe-optimized design patterns, especially when using 3rd party tools (such as Raincode Compiler) to automatically migrate mainframe code (COBOL/JCL etc) to T-SQL and C# .NET. Mainframe data accesses commonly employ Point-Lookups (AKA ‘Singleton Reads’) to loop through and join multiple large tables. This data access pattern is optimal for mainframe, but is suboptimal for querying SQL Server via .NET, where batching is recommended.

Files

Status: Live

This download is still available on microsoft.com. The downloads below will come directly from the Microsoft Download Center.

System Requirements

Operating Systems: Windows 10, Windows Server 2016

Microsoft Word

Installation Instructions

To start the download, click Download, click Go, and then do one of the following: To start the installation immediately, click Open or Run this program from its current location. To copy the download to your computer for installation at a later time, click Save or Save this program to disk.

This page was generated from a snapshot of the Microsoft Download Center made on .
Report a problem