加速星劍二資料庫(過回合時間) Speed UP SOTS II DB

2qwer.

加速星劍二資料庫(過回合時間) Speed UP SOTS II DB

資料來源：http://www.kerberos-productions.com/forum/viewtopic.php?f=50&t=48010

Speed UP SOTS II DB

Postby lordfrankoo » Thu Mar 28, 2013 11:37 am
Hi there!

Here is Speed UP DB script For late game turn times with two save games testing file attached :)
lordfranko.sots2save - original SOTSII savegame
lordfrankoo_new.SOTS2save - moded savegame

Turn wait times :
sots II orig file- 45 sec on turn 225
sots II modded file - 30~32 sec on turn 225
All UI screens especially Empire Screen load faster :)

Map Clusters VS 8 hard AI

Hete is how to do it :
1. Use SQLite expert personal to create NEW sots2save db with pagesize>=8192 (i created with 16834)
2. Run This Script (tested and running on SOTS II ver: 2.0.24917.6. is copying your save into the new DB nothing more :) )

UPgrade_DB.txt
    (134.81 KiB) Downloaded 100 times



LordFrankoo.part01.rar
    (1.39 MiB) Downloaded 33 times


LordFrankoo.part02.rar
    (1.39 MiB) Downloaded 43 times



Attachments of save files to see for yourself

Unfortunately some things as :
jornal_mode = memory,
cache_size = 50000
temp_store=memory
WaL-Autocheckpoint=100000

are reset when SOTS II create new save.

but most profit you get from page size it remain the same so when cache_size is returned to normal =2000
if you set page size (16834) then you have ~1400 pages and they are all cached not the original 16000 and up pages :)

journal mode- memory - writes transaction journal strictly in memory, even for in memory DB some times if its on default it uses hdd file :)
same for temp _store :)
Wal - write ahead log - default is 1000 which for SOTSII SQL insense operatios is too little


You will benefit from it when the game goes on... for longer time :) even if file goes bigger in my case size difference is 5 MB which is nothing

PS. Really bad English . 10 sec difference is 10 sec difference
Last edited by lordfrankoo on Sat Mar 30, 2013 11:50 am, edited 2 times in total.



Last savefile part

LordFrankoo.part03.rar
    (1.39 MiB) Downloaded 28 times


Also Add this index to savefile


CREATE INDEX [IDX_gen_unique] ON [gen_unique] ([player_id] COLLATE NOCASE ASC, [current] COLLATE NOCASE ASC);


Enjoy and comment

lordfrankoo 貼子中的文件打包下載：http://pan.baidu.com/share/link? ... 9&uk=1881927347


p.s.此方法未實測。




喵~

xcom333

征集小白鼠

knight610

其實比起回合速度過慢，我更難受的是設計艦船的時候點選武器都要等好久才能出列表……

史顽

knight610 发表于 2013-6-7 10:00
其實比起回合速度過慢，我更難受的是設計艦船的時候點選武器都要等好久才能出列表…… ...

这个我也遇到了，刚开始游戏时，没有迟钝，但时间久了就会有选武器迟钝的现象。不清楚是游戏本身优化问题还是电脑硬件的问题。。。。。。

sonicem

用了个174回合的档试了试,感觉没什么效果?

zxtmkyygy

看看情况

xyzyj2000

下載好了！但是不知道怎麼用！連放哪裡都不知道！