Windows high synchronization time

[televolt]

Hello, can anyone help me with this small issue? My "synchronization time" is too slow
I'm using a "virgin" datapack, "virgin" database, unique modification is a global map, nothing more
I'm using TFS 0.3.7, OTX 2.7, Win 7 ultimate 64bit, 8gb ram, fx 4300 3.8 ghz


*TFS 0.2

[30/09/2013 08:02:07] >> Loading map
[30/09/2013 08:02:08] > Map size: 34000x34000.
[30/09/2013 08:02:13] > Map loading time: 6.689 seconds.
[30/09/2013 08:06:54] Notice: Map load (relational) took: 279.68 s
[30/09/2013 08:06:54] >> Initializing gamestate

*TFS 0.3.7 or OTX 2.7

[12/8/2013 4:12:5] >>> Loading time: 10.674 seconds.
[12/8/2013 4:12:8] >>> Parsing time: 2.943 seconds.
[12/8/2013 4:13:49] >>> Synchronization time: 101.096 seconds.
[12/8/2013 4:13:49] >>> Unserialization time: 0.049 seconds.

 

[televolt]

Bump

 

[fluidsonic]

Assuming TFS 0.3.7-pre.

How many houses and auctions does your server have?
Synchronization time gets higher the more houses and auctions you have in your database.

More likely is a problem with your database.
Which one do you use? sqlite? MySQL?

If you use sqlite you should move to MySQL.
If you use MySQL you should read some guides on how to improve your MySQL database performance.

Also if you use MySQL you should run TFS on the same machine as the database, unless you already do so.

 

[televolt]

i was running this same server in my old pc with a normal sync time.(win vista 32 bit) i have changed dlls and exe to 64 bit, new dabase and my new pc is better :/
so i dont think its because of database or sqlite

you have any other ideia?

 

[fluidsonic]

Synchronization is very database-intense so the bottleneck is most likely there.
I don't think that there are any other options which would make sense.

You said that you have a new database. How did you update it and what database are you using now?

 

[televolt]

Same database but reseted, like a backup. Long long time ago, with the old pc vista, i had this same sync problem and i THINK it solved with some win atualization, servicepack or exorcism and i really dont know why


EDIT.

i have tested a basic tfs datapack with clean database and sync load still slow

[15/8/2013 11:53:48] >>> Loading time: 0.436 seconds.
[15/8/2013 11:53:48] >>> Parsing time: 0.061 seconds.
[15/8/2013 11:53:58] >>> Synchronization time: 9.793 seconds.
[15/8/2013 11:53:58] >>> Unserialization time: 0.005 seconds.

 

[televolt]

Bump bump

 

[televolt]

BUMP

 

[televolt]

bump

 

[televolt]

bump