program development issues

[tarbat]

In the past these types of problem have often been solved by excluding the Radarbox folders (and those in the Virtual Store) from virus scanning.

[wojteksz]

tarbat:
so i have heard but i have positively checked that the antivirus IS NOT reading the database file from AirNav directory. It can be easily done with sysinternals suite which i do use in my professional work with other database applications.
It is read/written by AirNav application only (to be precise by ANRB.exe)

when started (with Kaspersky Antivirus running all the time) the ANRB needs some 76M memory and up to some 3% processor time. After 30 minutes it is already 82M memory.

[tarbat]

What O/S?  And what installation directory?  If Win7 or Vista, and the default installation directory, then you will also have the complications of the Virtual Store.  In which case, I would recommend a full uninstall, and re-install somewhere like C:\ANRB

[wojteksz]

op system is XP pro, installed to c:\RadarBox

[tarbat]

so i have heard but i have positively checked that the antivirus IS NOT reading the database file from AirNav directory.

Even when Radarbox is actually running?

I guess there's a possibility that one of the ANRB databases has become corrupted.  If you've eliminated antivirus from scanning the radarbox folder, then I can't think of any other cause.  

Even after 20 hours running, my ANRB.EXE has only 31MB of private memory allocated.

Another question.  Just before you close Radarbox down, how big are the database journal files.  DATA\MyLog.db3-journal and DATA\NavData.db3-journal
If these files are large, then there's a problem with the database update process.

[wojteksz]

how to check databases? any tool available?

here with pl see my data for anrb.exe registered with procexp.exe (by wininternals):

after start but before connecting to the radarbox:
virtual memory 28M
phisical memory working set 32MB

after connecting to radarbox:
virtual memory 76M
phisical memory working set 79M

if you PM your email i will provide screenshots from procexpl where more detailed info can be seen.

as to the journal:
after start MyLog.db3-journal i between 0 and 30kb
NavData.db3-journal is 51kb and seems to stay at this value or slightly rise
NavData.db3-stmtjrnl is 4kb and stays at this value

[wojteksz]

testing loading HDD with search process:  while anrb.exe working the
MyLog.db3-journal stayed between 9 to 35kb and down to 0 after the search was over
NavData.db3-journal went to 62kb and stays at this value

[tarbat]

Sorry, I'm out of ideas.  The increases in memory usage might suggest that database updates are queueing up in memory, and the only reason I can think for that is an I/O lock on the databases.  If you've definately excluded the radarbox folders from virus scanning, then maybe you need to find what other process may be locking the databases.

This is simply a guess, I'm definately out of my depth now!!

[wojteksz]

It can not be the overall lock on databases as the MyLog database is working OK.
There may be a problem with NavData - can you send me your copy of this database so i could replace it with a database that is working?

[tarbat]

Why do you think there may be a problem with NavData?
Sorry, I'm away from my main PC at the moment.  Maybe try a full uninstall, and then re-install.

[AirNav Support]

wojteksz,

You memory stats that you posted above are fine and won't cause the issue. If you really do believe that its the  updates to database, you can go to File _> Preferences -> RadarBox and change Screen Refresh rate to 4000.

This will should mean the load should go down by 50%.

[wojteksz]

tarbat:
looks like a problem with navdata.db3 since
(1) the navdata.db3-jurnal is consistently growing and there is navdata.db3-stmtjnl existing and also growing (but much much slower)
(2) navdata.db3 has not been updated since start of the application
(3) navdata.bak has been updated
 
seems like justified assumption ;)

[wojteksz]

airnav support:
my screen refresh was set to 2000 and i have it modified to 4000 as advised.
result:
hdd seems to have a LITTLE lower workload, mylog.db3-jurnal between 0 and 30kb
navdata.db3-jurnal consistently growing

can joy pls let me know where i can get the good version of the navdata.db3 file? can i just delete it?