WitPTracker AE News

This new stand alone release based on the legendary War in the Pacific from 2 by 3 Games adds significant improvements and changes to enhance game play, improve realism, and increase historical accuracy. With dozens of new features, new art, and engine improvements, War in the Pacific: Admiral's Edition brings you the most realistic and immersive WWII Pacific Theater wargame ever!

Moderators: wdolson, MOD_War-in-the-Pacific-Admirals-Edition

floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: need to shrink DB

Post by floydg »

ORIGINAL: herwin

ORIGINAL: floydg

ORIGINAL: herwin

That's a standard problem with JDBC systems. You need to bug the developers to allow people to use alternative high-performance DBMSs.

Okay, I'm game - if it can improve performance, can you recommend something?

There are two problems--big databases are unavoidably slower, and the memory fragmentation you get in the JVM as you load a lot of data means you start thrashing. There was this FAA system I had some involvement with that ran into just that problem. I've asked the DBMS expert who sits two desks over for some suggestions.

For a starter, is the database normalised?

I believe the database is in 3NF.

The amount of data loaded is transient - once we get a "current" snapshot, the memory is freed, so in steady-state, the usage is relatively constant. The problem is building the current snapshot, which is the time killer.

Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
User avatar
n01487477
Posts: 4764
Joined: Tue Feb 21, 2006 12:00 am

RE: WitPTracker AE Release 1.0

Post by n01487477 »

ORIGINAL: n01487477
ORIGINAL: jcjordan
I minor thing I noticed on the alert tab was that in my game as Allies vs AI IJ that on the new month I get the msgs about a/c research being moved forward to x month....
Let me get this right ... you're seeing your opponents R&D on the first of the month ?

Oops ... I think I wrote this bit of code I forgot to filter for side ... found, done and fixed
herwin
Posts: 6047
Joined: Thu May 27, 2004 9:20 pm
Location: Sunderland, UK
Contact:

RE: need to shrink DB

Post by herwin »

ORIGINAL: floydg


I believe the database is in 3NF.

The amount of data loaded is transient - once we get a "current" snapshot, the memory is freed, so in steady-state, the usage is relatively constant. The problem is building the current snapshot, which is the time killer.

Floyd

What's probably killing the user is memory fragmentation during the load. You might look at advanced memory management techniques. Unfortunately, Java (and C#) aren't really designed for user control of memory usage. Do a Google search on Java memory fragmentation, and you'll find a number of articles on the subject. My colleague may get back to me later today.
Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
User avatar
n01487477
Posts: 4764
Joined: Tue Feb 21, 2006 12:00 am

RE: need to shrink DB

Post by n01487477 »

ORIGINAL: herwin

ORIGINAL: floydg


I believe the database is in 3NF.

The amount of data loaded is transient - once we get a "current" snapshot, the memory is freed, so in steady-state, the usage is relatively constant. The problem is building the current snapshot, which is the time killer.

Floyd

What's probably killing the user is memory fragmentation during the load. You might look at advanced memory management techniques. Unfortunately, Java (and C#) aren't really designed for user control of memory usage. Do a Google search on Java memory fragmentation, and you'll find a number of articles on the subject. My colleague may get back to me later today.
Just spent a little bit of time doing some stats on Tracker ... jconsole.exe (JDK) -heap dump-> Mem Analyser(eclipse). Gave me what I thought in the first place, the map is a memory hog ! This was with about 10 turns loaded, I'll compare with 100+



Image
Attachments
capture.jpg
capture.jpg (261.22 KiB) Viewed 262 times
User avatar
Zebedee
Posts: 535
Joined: Tue Aug 30, 2005 11:52 am

RE: need to shrink DB

Post by Zebedee »

Sent an e-mail to the techsupport address. Just can't get 64-bit Win 7 on this new AMD rig to recognise 32-bit Java :(
Image
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: need to shrink DB

Post by floydg »

ORIGINAL: n01487477
ORIGINAL: herwin

ORIGINAL: floydg


I believe the database is in 3NF.

The amount of data loaded is transient - once we get a "current" snapshot, the memory is freed, so in steady-state, the usage is relatively constant. The problem is building the current snapshot, which is the time killer.

Floyd

What's probably killing the user is memory fragmentation during the load. You might look at advanced memory management techniques. Unfortunately, Java (and C#) aren't really designed for user control of memory usage. Do a Google search on Java memory fragmentation, and you'll find a number of articles on the subject. My colleague may get back to me later today.
Just spent a little bit of time doing some stats on Tracker ... jconsole.exe (JDK) -heap dump-> Mem Analyser(eclipse). Gave me what I thought in the first place, the map is a memory hog ! This was with about 10 turns loaded, I'll compare with 100+

Next release will have the ability to hide the map. It is a huge image read in...
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
herwin
Posts: 6047
Joined: Thu May 27, 2004 9:20 pm
Location: Sunderland, UK
Contact:

RE: need to shrink DB

Post by herwin »

Yes, but the map is fixed size--it shouldn't be a big issue. You could consider using a proxy and only loading it as needed, but then you might run into out of memory problems later.
Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
herwin
Posts: 6047
Joined: Thu May 27, 2004 9:20 pm
Location: Sunderland, UK
Contact:

Replays Question

Post by herwin »

I've offered my opponent a 'mulligan' back about 5 days. I assume I need to reload all the .pws files up to that date...
Harry Erwin
"For a number to make sense in the game, someone has to calibrate it and program code. There are too many significant numbers that behave non-linearly to expect that. It's just a game. Enjoy it." herwin@btinternet.com
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: Replays Question

Post by floydg »

ORIGINAL: herwin

I've offered my opponent a 'mulligan' back about 5 days. I assume I need to reload all the .pws files up to that date...

Yeah, no way to "unload" turns.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: need to shrink DB

Post by floydg »

ORIGINAL: herwin

Yes, but the map is fixed size--it shouldn't be a big issue. You could consider using a proxy and only loading it as needed, but then you might run into out of memory problems later.

The loading takes a huge amount of time in addition to huge amount of memory. I'd need to profile it a little deeper to see where the bottleneck is, but for now, as I said, the option to turn it off will be available.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
User avatar
witpqs
Posts: 26376
Joined: Mon Oct 04, 2004 7:48 pm
Location: Argleton

RE: need to shrink DB

Post by witpqs »

Floyd, personally I've stopped using the map and just use the 'Z' key in-game. Having the search arcs on the map would be nice, but (reported a while back) they don't work right. Having the Z key, while not as good an overview as Tracker, is good enough. So an option to turn off the map would be great.


To recap, the problem with the search arcs is this (made up example to illustrate the key point):

Take a group with 9 planes and put it on 100% search. Tell it to search from 0d to 180d. Do 'show arcs' and you will see a morning search for half of the search (say 0d to 90d) and an afternoon search for the other half (say 90d to 180d).

Instead tell it to search 0d to 90d. Do 'show arcs' and you will see that 0d to 90d is searched both morning and afternoon.

Tracker - in both cases - will show a morning search for half and an afternoon search for half. In other words, it seems like Tracker just takes the starting place (0d), takes the number of planes set to search (planes and percentage set to search), and then counts out morning and afternoon searches. The ending place (90d) is not recognized.
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: need to shrink DB

Post by floydg »

ORIGINAL: witpqs

Floyd, personally I've stopped using the map and just use the 'Z' key in-game. Having the search arcs on the map would be nice, but (reported a while back) they don't work right. Having the Z key, while not as good an overview as Tracker, is good enough. So an option to turn off the map would be great.


To recap, the problem with the search arcs is this (made up example to illustrate the key point):

Take a group with 9 planes and put it on 100% search. Tell it to search from 0d to 180d. Do 'show arcs' and you will see a morning search for half of the search (say 0d to 90d) and an afternoon search for the other half (say 90d to 180d).

Instead tell it to search 0d to 90d. Do 'show arcs' and you will see that 0d to 90d is searched both morning and afternoon.

Tracker - in both cases - will show a morning search for half and an afternoon search for half. In other words, it seems like Tracker just takes the starting place (0d), takes the number of planes set to search (planes and percentage set to search), and then counts out morning and afternoon searches. The ending place (90d) is not recognized.

First time I've heard about this bug. But I see where in the code I've gone wrong: not checking the end position and just blowing through it.

Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
User avatar
Zebedee
Posts: 535
Joined: Tue Aug 30, 2005 11:52 am

RE: need to shrink DB

Post by Zebedee »

Just wanted to thank Floyd and the WitPtracker team for helping me get up and running.

Nice one :)
Image
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

Base data

Post by Roger Neilson II »

Have just tried an export of the Bases material - very useful potentially, but whilst it has supply data there is no fuel data? Oe of the key things i was looking for?

Roger
Image
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: Base data

Post by floydg »

ORIGINAL: Roger Neilson II

Have just tried an export of the Bases material - very useful potentially, but whilst it has supply data there is no fuel data? Oe of the key things i was looking for?

Roger

The export function only exports what's shown in the table. I can add fuel to the table so next release you'll be able to carefully count your barrels.

Floyd
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
User avatar
Roger Neilson II
Posts: 1419
Joined: Sun Jul 16, 2006 11:16 am
Location: Newcastle upon Tyne. England

RE: Base data

Post by Roger Neilson II »

That would be really useful.

Roger
Image
User avatar
witpqs
Posts: 26376
Joined: Mon Oct 04, 2004 7:48 pm
Location: Argleton

RE: need to shrink DB

Post by witpqs »

ORIGINAL: floydg

First time I've heard about this bug. But I see where in the code I've gone wrong: not checking the end position and just blowing through it.

Floyd

Thanks!
User avatar
vonTirpitz
Posts: 510
Joined: Tue Mar 01, 2005 6:30 pm
Location: Wilmington, NC
Contact:

RE: need to shrink DB

Post by vonTirpitz »

version 1.5.1

I have observed a minor nuisance that occurs when trying to load the Industry screen after some of the other screens have been viewed. For example, if I load and review the events, check out the victory screen and perhaps the Intel screen then go to Industry it won't display. I usually have to select another screen such as mines or whatnot and then the Industry screen again. It generally displays properly when selected after that. Kind of feels like perhaps a flag isn't being initialized set or cleared but just guessing.

Great utility though. Saves a player a lot of time trying to figure out what is where.... Thanks for all the hard work!

Marc
Image
erstad
Posts: 1957
Joined: Mon Aug 02, 2004 11:40 pm
Location: Midwest USA

RE: need to shrink DB

Post by erstad »

version 1.5.1

Very minor issue, but might be easy to address if it seems worthwhile.

On the LCU screen, when filtering for "Lack supply", all the LCU fragments loaded on ships show up, because the LCU drops its supply when it loads.

Since all loaded LCUs have no supply, and there's a lot of fragments, seems like it would be better to only list the LCUs on the ground.
floydg
Posts: 2081
Joined: Sat Jun 26, 2004 10:08 pm
Location: Middletown, NJ

RE: need to shrink DB

Post by floydg »

ORIGINAL: erstad

version 1.5.1

Very minor issue, but might be easy to address if it seems worthwhile.

On the LCU screen, when filtering for "Lack supply", all the LCU fragments loaded on ships show up, because the LCU drops its supply when it loads.

Since all loaded LCUs have no supply, and there's a lot of fragments, seems like it would be better to only list the LCUs on the ground.

Fixed.
Delete the trackerdb.* files.
Copy the pwsdll.dll file from the game folder to the WitPTracker folder.
Try running the WitPTracker.bat again.
Post Reply

Return to “War in the Pacific: Admiral's Edition”