performance issue on 64 bit JVM
Dear Derby Could you tell me how tuning the performance issue? This is running sample query to fetch data from Derby database On my dual-core XP x-32 laptop the Corporate Overview takes 406(ms). But we saw on the dual quad core it took 22973 (ms). I don't know why the performance became bad on my powerful machine. This is my test detail Query: select * from Customer; select * from product; select * from order; select * from Customer1; Dual-core XP SP3 32 bit,JDK1.6.0_25 32 bit, Dual quad core Windows 2008 64 bit, JDK1.6.0_25 64 bit, *32 bit Dual core Fetched record size: 1413 Fetch record time: 250 (ms) Fetched record size 8 Fetch record time: 15 (ms) Fetched record size: 6 Fetch record time: 0 (ms) Fetched record size: 1413 records Fetch record time: 141 (ms) total 406 ms **64 bit Dual quad core Fetched record size: 1413 Fetch record time: 11483 (ms) Fetched record size 8 Fetch record time: 3 (ms) Fetched record size: 6 Fetch record time: 4 (ms) Fetched record size: 1413 Fetch record time: 11484 (ms) total 22973 ms Thanks a lot Wangyang QA Group Jinfonet Software, Inc. www.jinfonet.com 2nd floor on the east of BEC Theatre 135 Xi Zhi Men Wai Street, Xicheng District Beijing, China 100044 yang.w...@support.jinfonet.com 86-10-68316633 JReport Embedded Reporting for Java Applications
Re: performance issue on 64 bit JVM
64-bit uses more memory, so if your Xmx is too small, the 64-bit version may have more GC overhead. You can increase Xmx or activate compressed-pointers to have a better memory usage. (Also the max heap size must fit in physical memory, otherwise the swap on disk could kill perfs.) Le 03/06/2011 04:09, QA Wang Yang a écrit : Dear Derby Could you tell me how tuning the performance issue? This is running sample query to fetch data from Derby database On my dual-core XP x-32 laptop the Corporate Overview takes 406(ms). But we saw on the dual quad core it took 22973 (ms). I don't know why the performance became bad on my powerful machine. This is my test detail Query: select * from Customer; select * from product; select * from order; select * from Customer1; Dual-core XP SP3 32 bit,JDK1.6.0_25 32 bit, Dual quad core Windows 2008 64 bit, JDK1.6.0_25 64 bit, *32 bit Dual core Fetched record size: 1413 Fetch record time: 250 (ms) Fetched record size 8 Fetch record time: 15 (ms) Fetched record size: 6 Fetch record time: 0 (ms) Fetched record size: 1413 records Fetch record time: 141 (ms) total 406 ms **64 bit Dual quad core Fetched record size: 1413 Fetch record time: 11483 (ms) Fetched record size 8 Fetch record time: 3 (ms) Fetched record size: 6 Fetch record time: 4 (ms) Fetched record size: 1413 Fetch record time: 11484 (ms) total 22973 ms Thanks a lot Wangyang QA Group Jinfonet Software, Inc. www.jinfonet.com 2nd floor on the east of BEC Theatre 135 Xi Zhi Men Wai Street, Xicheng District Beijing, China 100044 yang.w...@support.jinfonet.com 86-10-68316633 JReport Embedded Reporting for Java Applications
SYSCS_UTIL.SYSCS_BACKUP_DATABASE failing
Hi Team, we are using below proc for backing up the database, but this call is hanging when the Database is size more like 3GB, 4GB, ... Can you let me know in which case we can use this and also what else we need to use to backup database incase if the siz is more. CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?) Best Regards, Vijender D, Deutsche Bank Ph: +65 6423 8530 Mobile: +65 94517994 This mail is transmitted to you on behalf of [HCL]. Diese Post wird Ihnen im Namen der [HCL] ubermittelt * --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Re: performance issue on 64 bit JVM
Unless you need to address heap over 32bit JVM limits use 32bit JVM. Just my EUR .02 :-) 2011/6/3 Arnaud Masson amas...@gmail.com: 64-bit uses more memory, so if your Xmx is too small, the 64-bit version may have more GC overhead. You can increase Xmx or activate compressed-pointers to have a better memory usage. (Also the max heap size must fit in physical memory, otherwise the swap on disk could kill perfs.) Le 03/06/2011 04:09, QA Wang Yang a écrit : Dear Derby Could you tell me how tuning the performance issue? This is running sample query to fetch data from Derby database On my dual-core XP x-32 laptop the Corporate Overview takes 406(ms). But we saw on the dual quad core it took 22973 (ms). I don't know why the performance became bad on my powerful machine. This is my test detail Query: select * from Customer; select * from product; select * from order; select * from Customer1; Dual-core XP SP3 32 bit,JDK1.6.0_25 32 bit, Dual quad core Windows 2008 64 bit, JDK1.6.0_25 64 bit, *32 bit Dual core Fetched record size: 1413 Fetch record time: 250 (ms) Fetched record size 8 Fetch record time: 15 (ms) Fetched record size: 6 Fetch record time: 0 (ms) Fetched record size: 1413 records Fetch record time: 141 (ms) total 406 ms **64 bit Dual quad core Fetched record size: 1413 Fetch record time: 11483 (ms) Fetched record size 8 Fetch record time: 3 (ms) Fetched record size: 6 Fetch record time: 4 (ms) Fetched record size: 1413 Fetch record time: 11484 (ms) total 22973 ms Thanks a lot Wangyang QA Group Jinfonet Software, Inc. www.jinfonet.com 2nd floor on the east of BEC Theatre 135 Xi Zhi Men Wai Street, Xicheng District Beijing, China 100044 yang.w...@support.jinfonet.com 86-10-68316633 JReport Embedded Reporting for Java Applications
Re: SYSCS_UTIL.SYSCS_BACKUP_DATABASE failing
There should be no size limits to the backup database command other than those imposed by destination disk/filesystem. Are you sure it is hanging, rather than going very slow? Basically is anything showing up on the destination disk. Is there anything in derby.log when you encounter the problem? Are you trying to backup the database while work is being done in the database? If so, derby does have to wait until current tranactions finish before it can get started. I would not be surprised if backup done by derby is slower than one would expect, it has not been optimized for very large databases. It is basic. The expectation is that if the solution is not fast enough then user can code their own backup and properly interact with derby by using method outlined in the documentation using freeze or unfreeze: http://db.apache.org/derby/docs/10.8/adminguide/cadminhubbkup98797.html http://db.apache.org/derby/docs/10.8/adminguide/cadminhubbkup75469.html Vijender Devakari wrote: Hi Team, we are using below proc for backing up the database, but this call is hanging when the Database is size more like 3GB, 4GB, ... Can you let me know in which case we can use this and also what else we need to use to backup database incase if the siz is more. CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?) Best Regards, Vijender D, Deutsche Bank Ph: +65 6423 8530 Mobile: +65 94517994 This mail is transmitted to you on behalf of [HCL]. Diese Post wird Ihnen im Namen der [HCL] ubermittelt * --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.
Re: performance issue on 64 bit JVM
QA Wang Yang yang.w...@support.jinfonet.com writes: Dear Derby Could you tell me how tuning the performance issue? This is running sample query to fetch data from Derby database On my dual-core XP x-32 laptop the Corporate Overview takes 406(ms). But we saw on the dual quad core it took 22973 (ms). I don't know why the performance became bad on my powerful machine. Did you check if Derby selected another (less optimal) execution plan on the powerful machine? http://db.apache.org/derby/docs/10.8/tuning/ctundepth853133.html Dag This is my test detail Query: select * from Customer; select * from product; select * from order; select * from Customer1; Dual-core XP SP3 32 bit,JDK1.6.0_25 32 bit, Dual quad core Windows 2008 64 bit, JDK1.6.0_25 64 bit, *32 bit Dual core Fetched record size: 1413 Fetch record time: 250 (ms) Fetched record size 8 Fetch record time: 15 (ms) Fetched record size: 6 Fetch record time: 0 (ms) Fetched record size: 1413 records Fetch record time: 141 (ms) total 406 ms **64 bit Dual quad core Fetched record size: 1413 Fetch record time: 11483 (ms) Fetched record size 8 Fetch record time: 3 (ms) Fetched record size: 6 Fetch record time: 4 (ms) Fetched record size: 1413 Fetch record time: 11484 (ms) total 22973 ms Thanks a lot Wangyang QA Group Jinfonet Software, Inc. www.jinfonet.com 2nd floor on the east of BEC Theatre 135 Xi Zhi Men Wai Street, Xicheng District Beijing, China 100044 yang.w...@support.jinfonet.com 86-10-68316633 JReport Embedded Reporting for Java Applications