did not read the full thread, when I first run this version, I see the folloing messages, are there any problems?
TRUNCATE TABLE trade
nxt.db.TransactionalDb$DbStatement.executeUpdate(TransactionalDb.java:259)
nxt.db.DerivedDbTable.truncate(DerivedDbTable.java:57)
nxt.db.EntityDbTable.truncate(EntityDbTable.java:429)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1503)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1464)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1448)
nxt.BlockchainProcessorImpl.lambda$new$17(BlockchainProcessorImpl.java:799)
nxt.BlockchainProcessorImpl$$Lambda$6/517052730.run(Unknown Source)
nxt.util.ThreadPool$2.run(ThreadPool.java:131)
2015-06-09 11:09:39 FINE: SQL statement required 17.848 seconds at height 445299:
TRUNCATE TABLE asset_transfer
nxt.db.TransactionalDb$DbStatement.executeUpdate(TransactionalDb.java:259)
nxt.db.DerivedDbTable.truncate(DerivedDbTable.java:57)
nxt.db.EntityDbTable.truncate(EntityDbTable.java:429)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1503)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1464)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1448)
nxt.BlockchainProcessorImpl.lambda$new$17(BlockchainProcessorImpl.java:799)
nxt.BlockchainProcessorImpl$$Lambda$6/517052730.run(Unknown Source)
nxt.util.ThreadPool$2.run(ThreadPool.java:131)
2015-06-09 11:09:39 FINE: Rolled back derived tables
2015-06-09 11:11:19 FINE: SQL statement required 98.936 seconds at height 0:
SELECT * FROM block WHERE height >= ? ORDER BY db_id ASC
nxt.db.TransactionalDb$DbPreparedStatement.executeQuery(TransactionalDb.java:287)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1527)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1464)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1448)
nxt.BlockchainProcessorImpl.lambda$new$17(BlockchainProcessorImpl.java:799)
nxt.BlockchainProcessorImpl$$Lambda$6/517052730.run(Unknown Source)
nxt.util.ThreadPool$2.run(ThreadPool.java:131)
2015-06-09 11:33:19 INFO: processed block 260000
2015-06-09 11:34:16 FINE: SQL statement required 10.382 seconds at height 263597:
MERGE INTO account_asset (account_id, asset_id, quantity, unconfirmed_quantity, height, latest) KEY (account_id, asset_id, height) VALUES (?, ?, ?, ?, ?, TRUE)
nxt.db.TransactionalDb$DbPreparedStatement.executeUpdate(TransactionalDb.java:298)
nxt.Account$AccountAsset.save(Account.java:83)
nxt.Account$AccountAsset.access$1900(Account.java:49)
nxt.Account$10.save(Account.java:454)
nxt.Account$10.save(Account.java:445)
nxt.db.EntityDbTable.insert(EntityDbTable.java:402)
nxt.Account$AccountAsset.save(Account.java:106)
nxt.Account$AccountAsset.access$3900(Account.java:49)
nxt.Account.addToUnconfirmedAssetBalanceQNT(Account.java:1156)
nxt.TransactionType$ColoredCoins$3.applyAttachmentUnconfirmed(TransactionType.java:1374)
nxt.TransactionType.applyUnconfirmed(TransactionType.java:200)
nxt.TransactionImpl.applyUnconfirmed(TransactionImpl.java:999)
nxt.BlockchainProcessorImpl.accept(BlockchainProcessorImpl.java:1164)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1564)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1464)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1448)
nxt.BlockchainProcessorImpl.lambda$new$17(BlockchainProcessorImpl.java:799)
nxt.BlockchainProcessorImpl$$Lambda$6/517052730.run(Unknown Source)
nxt.util.ThreadPool$2.run(ThreadPool.java:131)
2015-06-09 11:34:30 INFO: processed block 265000
2015-06-09 11:40:54 INFO: processed block 285000
2015-06-09 11:41:13 FINE: SQL statement required 11.153 seconds at height 285732:
INSERT INTO asset_transfer (id, asset_id, sender_id, recipient_id, quantity, timestamp, height) VALUES (?, ?, ?, ?, ?, ?, ?)
nxt.db.TransactionalDb$DbPreparedStatement.executeUpdate(TransactionalDb.java:298)
nxt.AssetTransfer.save(AssetTransfer.java:180)
nxt.AssetTransfer.access$200(AssetTransfer.java:32)
nxt.AssetTransfer$2.save(AssetTransfer.java:58)
nxt.AssetTransfer$2.save(AssetTransfer.java:49)
nxt.db.EntityDbTable.insert(EntityDbTable.java:402)
nxt.AssetTransfer.addAssetTransfer(AssetTransfer.java:129)
nxt.TransactionType$ColoredCoins$2.applyAttachment(TransactionType.java:1273)
nxt.TransactionType.apply(TransactionType.java:219)
nxt.Attachment$AbstractAttachment.apply(Attachment.java:68)
nxt.TransactionImpl.apply(TransactionImpl.java:1019)
nxt.BlockchainProcessorImpl.accept(BlockchainProcessorImpl.java:1178)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1564)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1464)
nxt.BlockchainProcessorImpl.scan(BlockchainProcessorImpl.java:1448)
nxt.BlockchainProcessorImpl.lambda$new$17(BlockchainProcessorImpl.java:799)
nxt.BlockchainProcessorImpl$$Lambda$6/517052730.run(Unknown Source)
nxt.util.ThreadPool$2.run(ThreadPool.java:131)
2015-06-09 11:42:27 INFO: processed block 290000