Hi,everone!
I use JE DPL API to insert(put) my entity named AuthService with 5 SecondaryKey,40 fields.
Excute Insert 100000 Records, total times 40172ms, 2456 Records/sec ,quite slow!!!,why??? can i tune it up?
tx commit execute step is 1000 Records。
My OS is:
===========================================================
Win XP2
Interl CPU T2080 1.73GHZ*2
2.0GB Memory Size
160GB Disk Size
-Xmx1024M
My Environment Configs is:
===========================================================
EnvironmentConfig envConfig = new EnvironmentConfig();
envConfig.setAllowCreate(true);
envConfig.setTransactional(true);
envConfig.setCacheSize(300*1024*1024);
envConfig.setTxnNoSync(false);
envConfig.setTxnWriteNoSync(true);
StoreConfig storeConfig = new StoreConfig();
storeConfig.setAllowCreate(true);
storeConfig.setTransactional(true);
EntityStore store = new EntityStore(env, "AuthService", storeConfig);
Transaction tx = store.getEnvironment().beginTransaction(null, null);
AuthServiceAccenssor asAcc = new AuthServiceAccenssor(store);
asAcc.loadAuthServiceDb(store, tx, records, step);
My entity named AuthService is:
===============================================================
@PrimaryKey
public String id;
@SecondaryKey(relate = MANY_TO_ONE)
public String userid;
@SecondaryKey(relate = MANY_TO_ONE)
public String areaid;
@SecondaryKey(relate = MANY_TO_ONE)
public String netid;
@SecondaryKey(relate = MANY_TO_ONE)
public String stockid;
@SecondaryKey(relate = MANY_TO_ONE)
public String productid;
.....................
long i = 0;
AuthService = new AuthService();
while (true) {
String id = String.valueOf(i++);
as.id = id;
as.userid = "userid"+id;
as.areaid = "areaid"+id;
as.netid = "netid"+id;
as.stockid= "stockid"+id;
as.productid = "productid"+id;
as.productname = "Digital TV set-top boxes"+id;
as.isgroup ="1";
as.paymode = "cashe";
as.createdate = new Date();
as.startdate =new Date();
as.enddate = new Date();
as.pausedate = new Date();
as.resumedate = new Date();
as.realstartdate = new Date();
as.realenddate = new Date();
as.formerstatus ="0";
as.status= "1";
as.freestartdate = (new Date());
as.freeenddate = (new Date());
as.refpricefix = 933l;
as.pricefix = 923l;
as.isrenew = "1";
as.auditorid = "auditorid"+i;
as.auditdate = new Date();
as.auditremark = "argee!argee!";
as.ispass ="1";
as.operatorid ="Operatorid"+i;
as.operatedate = new Date();
as.billid = "billid"+i;
as.closedate = new Date();
as.issendcmdahead = "0";
as.remark ="";
as.divideid = "divideid"+i;
as.billTypeId = "billTypeId"+i;
as.billingCyclecount = 14304;
as.orderUserId = "userid"+i;
as.isGenBankPayRecord = "234";
as.isBankPay = "1";
as.billingCount = 123;
as.productInstanceId = "ProductInstanceId"+i;
as.billingCyclePeriodValue = 324;
as.productInstanceName ="Digital TV set-top boxes Purchase";
as.cmngStbTypeName = "persional customer!";
authServiceById.putNoReturn(tx,as);
if ( i% steps == 0){
tx.commit();
tx=null;
tx = store.getEnvironment().beginTransaction(null, null);
}
if ( i % records == 0){
break;
}
}
My Stats is:
===============================================================
Compression stats
splitBins=0
dbClosedBins=0
cursorsBins=0
nonEmptyBins=0
processedBins=0
inCompQueueSize=0
Eviction stats
nEvictPasses=0
nNodesSelected=0
nNodesScanned=0
nNodesExplicitlyEvicted=0
nRootNodesEvicted=0
nBINsStripped=0
requiredEvictBytes=0
Checkpoint stats
nCheckpoints=6
lastCheckpointId=6
nFullINFlush=602
nFullBINFlush=439
nDeltaINFlush=1,578
lastCheckpointStart=0xa/0x20f8ad
lastCheckpointEnd=0xa/0x2a540b
endOfLog=0xa/0x7a4c53
Cleaner stats
cleanerBacklog=0
nCleanerRuns=0
nCleanerDeletions=0
nINsObsolete=0
nINsCleaned=0
nINsDead=0
nINsMigrated=0
nLNsObsolete=0
nLNsCleaned=0
nLNsDead=0
nLNsLocked=0
nLNsMigrated=0
nLNsMarked=0
nLNQueueHits=0
nPendingLNsProcessed=0
nMarkedLNsProcessed=0
nToBeCleanedLNsProcessed=0
nClusterLNsProcessed=0
nPendingLNsLocked=0
nCleanerEntriesRead=0
Cache stats
nNotResident=0
nCacheMiss=0
nLogBuffers=3
bufferBytes=3,145,728
dataBytes=106,651,450
adminBytes=5,559
lockBytes=560
cacheTotalBytes=109,803,297
sharedCacheTotalBytes=0
nSharedCacheEnvironments=0
IO Stats
nRandomReads=0
nRandomWrites=11
nSequentialReads=13
nSequentialWrites=185
nRandomReadBytes=0
nRandomWriteBytes=418
nSequentialReadBytes=26,624
nSequentialWriteBytes=108,012,175
Logging stats
nFSyncs=7
nFSyncRequests=7
nFSyncTimeouts=0
nRepeatFaultReads=0
nTempBufferWrite=0
nRepeatIteratorReads=0
nFileOpens=24
nOpenFiles=0
totalLogSize=108,012,175
records:100000
Excute TestJEDPLAS Read total times 9516ms
分享到:
相关推荐
C++ High Performance Boost and optimize the performance of your C++17 code_Code 源码 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
Learn how to identify, prioritize, and analyze problems, and then—most importantly—how to optimize performance. Learn how to test web pages and understand the results Determine if you have ...
The Guide concludes with recent performance benchmarks conducted with the MySQL Cluster database, an overview of how MySQL Cluster can be integrated with other MySQL storage engines, before ...
C++ High Performance Boost and optimize the performance of your C++17 code 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
本手册介绍了有关为英特尔微处理器优化代码所需的一切,包括奔腾,奔腾MMX,奔腾Pro,奔腾II,奔腾III,奔腾4,赛扬和至强。
Intel® Integrated Performance Primitives How to Optimize Software Applications Using Intel® IPP by Stewart Taylor
This book contains tips, tricks, and ... How should you optimize? And how can you measure how well your application is performing? These are some of the questions that are answered in this book.
DB2 problem determination using db2top utility Optimize performance and prevent problems in complex DB2environments
And you'll discover the bottlenecks in Rails code and learn how selective attribute loading and preloading can mitigate the performance costs of ActiveRecord. As you advance to Ruby performance ...
《C++高性能编程》这本书旨在帮助开发者提升C++17代码的性能,通过优化技术来最大化程序效率。C++作为一种强大的编程语言,其性能优化是一个关键领域,它涉及到内存管理、算法优化、并行计算等多个方面。...
And you’ll discover the bottlenecks in Rails code and learn how selective attribute loading and preloading can mitigate the performance costs of ActiveRecord. As you advance to Ruby performance ...
- A: When using CanFestival on the Motorola HC12, consider the limited memory resources and optimize the code accordingly. - **Q: How does CanFestival handle interrupts on the HC12?** - A: Can...
Optimize the performance of your mobile websites and webapps to the extreme. With this hands-on book, veteran mobile and web developer Maximiliano Firtman demonstrates which aspects of your site or ...
Along the way, he introduces techniques and sample code designed to streamline development, eliminate complexity, optimize performance, and leverage all iPhone’s native capabilities—from its ...