method for combining database optimization and program optimization
The invention discloses a method for combining database optimization and program optimization. The method comprises the following steps: S1, accessing an application system server; S2, calling an SQLstatement; S3, reading the SQL statement by the application system server; S4, the application system...
Gespeichert in:
Hauptverfasser: | , , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention discloses a method for combining database optimization and program optimization. The method comprises the following steps: S1, accessing an application system server; S2, calling an SQLstatement; S3, reading the SQL statement by the application system server; S4, the application system server calls an SQL optimizer to optimize SQL statements; S5, the application system server performs program optimization; And S6, re-executing the optimized application system. According to the method, the database optimization process and the program optimization process are organically fused together, so that the optimization of the system performance is promoted.
本发明公开了一种结合数据库调优和程序调优的方法,包括如下步骤:S1、访问应用系统服务器;S2、调用SQL语句;S3、应用系统服务器读取SQL语句;S4、应用系统服务器调用SQL优化器优化SQL语句;S5、应用系统服务器进行程序优化;S6、重新执行优化后的应用系统。本发明将数据库调优和程序调优的过程有机融合在一起,促进了系统性能的调优。 |
---|