The 10th tip of DB Query Analyzer
--Higher efficiency to export SQL result by DB Query Analyzer than DB2
( GuangDong Unitoll Services incorporated, GuangZhou 510300)
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 website
http://xiazai.zol.com.cn / .
It is one of the twenty most frequently download
In the New products & Tools reviews of programmer second issue of 2007, DB Query Analyzer had been strongly recommended.
By November 9, 2009 ,you would get 1500 thousand result with the key word ‘DB Query Aanlyzer’ in Google. In Baidu you would 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.
In the latest version 4.01, a useful function is added. Users can save the result with too many 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 would be low efficient.
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 64GB 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 includes the time that almost 2GB 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 above. The file exported is about 2GB.
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
In the part 4 , I will show you why DB Query Analyzer has the higher efficiency.
Figure 1Connect to DB2, Export 11,000,000 records within about 14 minutes, file size is about 2GB in PC Client
Export 11,000,000 records within about 6 minutes, file size is about 2GB in the DB2 server IBM 670 above
Figure 3 Connect to MS SQL Server, Export 2000 thousand records within about 2 minutes, file size is about 500MB
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.
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
DB Query Analyzer Simplified Chinese
My blogs are
Please uninstall the former version first, then install the latest version.
- DICOM Query 和Retrieve 的方法和定义 概要在用DCMTK库来写query和retrieve的时候查询条件的定义不是很清楚,DICOM的query和数据库的select有什么区别呢?Query即C-Find,Retrieve即C-Move,在放射影像设备、系统中是仅次于C-sto
- DICOM Query 和Retrieve 在用DCMTK库来写query和retrieve的时候查询条件的定义不是很清楚,DICOM的query和数据库的select有什么区别呢?Query即C-Find,Retrieve即C-Move,在放射影像设备、系统中是仅次于C-store
- 《Microsoft Sql server 2008 Internals》读书笔记--第八章The Query Optimizer(8). 读书笔记订阅地址：http://blog.csdn.net/downmoon/category/647266.aspx/rss《MicrosoftSqlserver2008Internals》索引目录：《MicrosoftSqlserver
- 【转】ASP.NET页面传值汇总 (Session / Server.Transfer / Query String /  ASP.NET页面传值汇总(Session/Server.Transfer/QueryString/Cookie/Application)2008-08-1217:25byLanceZhang,2551visits,收藏,编辑原文地址：ht
- Au second o vous comprendre cette query Ausecondovouscomprendrecettequery,vousparlezexactementlammerequtelaraisonpourlaquellepeutbasprixbacsdetransportparautoca