Optimizing software applications

摘要

Techniques for optimizing a software application include receiving, at a local computing system, a query from an application for data stored on a database table, the query including a context defined by a name of the database table; comparing the context of the query to a context of a predefined query scenario; based on the context of the query matching the context of the predefined query scenario, retrieving data stored on a secondary database replicated from data stored on a main database; and passing the retrieved data from the secondary database to the application.

主权项

1. A method performed with a computing system for optimizing a performance of an enterprise application, the method comprising:
receiving, at the local computing system that comprises an enterprise computing system, from a remote computing system that executes a hosted application, one or more configuration tables defining a predefined query scenario for querying and retrieving data from the hosted application for data stored on a database table; replicating a database table from a main database to a secondary database, the main database comprising updated data relative to data contained in the database table of the secondary database, the secondary database comprising an in-memory database and the main database comprising a magnetic memory; receiving, at the local computing system, a query from the enterprise application for data stored on the database table, the query comprising a query return time and a context; comparing the context of the query to a context of the predefined query scenario, the context of the query comprising at least one of a database table name, a scenario application name, or a scenario job name; based on the context of the query matching the context of the predefined query scenario, retrieving data stored on the secondary database replicated from data stored on the main database; and passing the retrieved data from the secondary database to the enterprise application.