FJ Software

While trying to figure out why it takes MyPhoneExplorer 10 seconds to save my settings (another thread), I saw that MyPhoneExplorer reads zipcodes.mdb every 5 seconds, when MyPhoneExplorer is otherwise completely inactive, even with no phone connected. This seems a bit unnecessary to me - is it really important to do that?

Here is a log from File Monitor from Sysinternals:

78 15:21:48 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
79 15:22:43 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
80 15:22:48 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
81 15:22:53 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
82 15:22:58 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
83 15:23:03 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
84 15:23:08 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
85 15:23:13 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
86 15:23:18 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
87 15:23:23 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
88 15:23:28 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
89 15:23:33 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
90 15:23:38 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
91 15:23:43 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
92 15:23:48 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
93 15:23:53 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
94 15:23:58 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
95 15:24:03 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
96 15:24:08 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
97 15:24:13 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
98 15:24:18 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
99 15:24:23 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
100 15:24:28 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
101 15:24:33 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512
102 15:24:38 MyPhoneExplorer:3260 READ C:\Program Files\MyPhoneExplorer\zipcodes.mdb SUCCESS Offset: 3584 Length: 512

MyPhoneExplorer doesn't make a request every 5 seconds. This is done by the OBDC-Driver from microsoft.

Okay. And I guess MyPhoneExplorer does not talk to the ODBC driver when MyPhoneExplorer is idle?

If so, I guess that the many reads of the database file is because the database connection is kept open by MyPhoneExplorer even when MyPhoneExplorer is idle? If that is the case, what is the reason for keeping the connection open when MyPhoneExplorer is idle?

And could it be possible that if MyPhoneExplorer opened the database in exclusive mode, the ODBC driver will not have to read the database file every 5 seconds looking for external changes?

OK - the thing with Exclusive mode could be a solution. I'll check it out

Thanks!