Method of improving database querying efficiency in looping programming of transformer

The invention relates to computer aided design of transformer design programs, in particular to a method of improving database querying efficiency in looping programming of a transformer. The method includes the steps of acquiring parameters of transformer design to be looped; storing parameter data of the transformer design into a transformer parameter database; creating blank tables in a transformer parameter database file; setting arrays in a looping program; determining ranges of values according to related parameter values of the transformer, selected in the looping program compiled by the aid of computer software VC++; according to the determined the ranges of values, querying values in the transformer parameter database file by the SQL (structured query language), and writing the values into the corresponding arrays set in the step 4; writing the values in the arrays into corresponding fields of the blank tables 2; subjecting the data in the blank tables 2 to looping. The method has the advantages that the database reading time in existing looping design programs of transformers is effectively shortened, database query time is shortened, and program running efficiency is improved.