The 10th tip of DB query Analyzer

 

The 10th tip of DB query Analyzer

-- Higher efficiency to export SQL result by DB query analyzer than B2

 

Ma gen-Feng

(Guangdong unitoll services ininitialized ated, Guangzhou 510300)

 

AbstractIn the latest version 4.01, a useful function is added in dB query analyzer. users can save the result fetched with too into records into file in high efficiency. further more, you can define the restrict character and determine 'export result to file with title' before to save the result fetched. so that you can export tables in some certain requirement that's not permitted in DBMS.

Key wordsDB query analyzer; Save the result fetched; DB2

 

1Brief introduction of DB Query anzyer 

DB query analyzer is presented by Master Gen Feng, Ma from Chinese Mainland. It has English version and Simplified Chinese version.

After four years research, design, development and about three months integrated test based on Oracle, Sybase, DB2, Informix, ms SQL Server, MySQL, MS access, Foxpro and paradox, DB query analyzer is presented to the world in 2007. from then on, the continuous improvement of function or interface has been done. now the latest version is 3.02.

Untill now it has been downloaded about ninety thousand times in the famous software download websitehttp: // xiazai.zol.com.cn/. It is one of the twenty most frequently download software.

In the new products & Tools reviews of programmer second issue of 2007, DB query analyzer had been stronugly recommended.

By November 9, 2009, you wocould get 1500 thousand result with the key word 'db query aanlyzer 'in Google. In Baidu you wocould get 40 thousand result.

Out of question, DB query analyzer is one of the few excellent client tools in the world for its 'powerful function, friendly interface, easy operation and applicability to every production of RDBMS.

 

2 New character in version 4.01

In the latest version 4.01, a useful function is added. Users can save the result with too records into file in high efficiency. I will show you how it works in the article.

The result of SQL can be written to file directly after you select "query-> display-> savetofile ". this function is much valuable in the case when records count is more than 20 thousand. if records count is between 10 thousand and 20 thousand, you can also display the result by grid, but you can't display the result by text because it wocould be low efficient.

 

3 Example to show the high efficient function

I will show you a comparison between the high efficiency of saving result to file by DB Query Analyzer and Export function by DB2 server IBM 670 with 64 GB memory, 8 physical CPU, 16 logical CPU, serial storage. to export about 11,000,000 records uses about 15 minutes with DB Query Analyzer in PC Client. of course, it uses des the time that almost 2 GB data transfer from Server to PC Client. to export about same mount records uses about 6 minutes with DB2 export function in the DB2 server IBM 670 abve. the file exported is about 2 GB.

Figure 1 shows it costs about 14 minutes to export SQL result by DB Query Analyzer. while it costs about 6 minutes by DB2 EXPORT. at first glance, DB2 EXPORT has the higher efficiency. but In more case, we might have the result file in our PC Client. so do you ever think how long the process of 2 GB file FTP to the PC Client wocould cost you?

In the part 4, I will show you why dB query analyzer has the higher efficiency.

 

 

Figure 1 connect to DB2, export 11,000,000 records within about 14 minutes, file size is about 2 GB in PC Client

 

Figure 2 Export 11,000,000 records within about 6 minutes, file size is about 2 GB in the DB2 server IBM 670 abve

 

Figure 3 connect to ms SQL Server, export 2000 thousand records within about 2 minutes, file size is about 500 mb

 

 

Figure 4 connect to ms SQL Server, export 2000 thousand records within nearly 14 seconds, file size is about 80 mb

 

 

4 Higher efficiency to export SQL result by DB Query Analyzer than DB2

In more case, we might have the result file in our PC client. So we has to think about the time used by the file FTP to the PC client.

Figure 5 about 15 minutes used the 2 GB result file FTP to the PC Client

 

So the whole process will cost about 21 minutes by DB2 export and FTP. On the contrary, it only costs about 15 minutes by DB query analyzer.

 

 

 

 
 

 

 

 

DB query analyzer 5.03 download URL:
Http://xiazai.zol.com.cn/detail/43/420901.shtml
Http://www.unitedpowersoft.com/UpFile/DBQueryAnalyzer_English_503.rar

 

DB query analyzer Simplified Chinese version 5.03 download URL:
Http://xiazai.zol.com.cn/detail/27/264455.shtml
 
 

 

My blogs are

Http://blog.csdn.net/magenfeng

Http://blog.sina.com.cn/magenfeng

Http://user.qzone.qq.com/630414817

 

 

Remarks:

Please uninstall the former version first, then install the latest version.