数据库程序优化浅谈

一个程序不仅要实现其功能,而且要综合其语言特点,达到最优化。数据库程序优化主要表现在如何使用数据库语言提高其运行速度。主要措施是:①应减少文件数。②采用优化语言提高程序的运行速度。③应减少语句条数,能写在一行的语句,就不要写成多行。④要充分利用数据库的内存变量,宏代换,格式文件,达到提高速度的目的。

Discussing Optimization of programs of Data Base

A program not only fulfils its function,but also reaches its optimization by synthesiz-ing characteristics of its language. Optimization of programs of data base mainly showshow to make use of language of data base so as to increase the speed of motion. Majarmeasures are:①The number of documents should be reduced. ②Optimum sentenessshould be adopted to raise the moving speed of program. ③The number of sentencesshould be reduced, that is, long as sentences can be written in one line, not written in manylines. ④In order to increase speed,good use should be made of intermal storage Variablesof data base, macro-transformation, form documents.