Hi all,

I have a problem with my Magic 9 app. and Pervasive 8. A specific part of
our software continuosly checks if there's new data and updates the
database. If not, the software idles for half a minute and checks again.
While the software is checking and updating, the utilisation on the server
(Dual processor Win2k server with 1,5Gb mem) goes for 99% to ntdbsmgr.exe
and when it idles the utilisation goes down to 6%.
When we use the application without the updating program, there are no
problems at all, the utilisation stays at 6-10%.

I saw some postings about this problem, but couldn't find a real solution.
Is there any solution? Or does somebody else hav the same problem?

Greetings
Barry

Sounds like the app has a design flaw. Based on the results, I'd say it was
performing a full table-scan every time through. If the file is large, this
will generate a LOT of accesses. Confirm this by watching the process in the
Pervasive Monitor and see what it is doing there.

Can you restrict the app to check ONLY for the value of a given key? For
example, set a byte to 0 when the value needs to be processed and create a key
on this byte. Then, as you process the records, set the byte to 1 (processed)
and move on to the next one.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Coming Soon: Pervasive DataExchange Training!


Barry van den Reek wrote:

Thanks Bill for your help.

After a little research I saw that the specific file was 4,8 Gb in size. It
was splitted in three, Allinput.fil (2Gb), Allinput.^01(2Gb) and
Allinput.^02 (800 Mb)
The used space was only "air", because after a rebuild the file size was
Allinput.fil (25Mb). Strange thing is that in version 7 from Pervasive the
empty space in a file was re-used (The file size didn't grow much because we
add records at the end, and delete records at the beginning in a ongoing
task) but now in Pervasive 8 the file grows with 3 Mb a day, but when we
rebuild it goes back to about 25Mb.
Does this sound familiar and what can i do about it?

Greetings
Barry

"Barry van den Reek" <barry (AT) liemar (DOT) nl> wrote

Sounds like a bug. Are you running V8.6 on the server? I seem to
recall a problem like this in V8.0, but I thought it was fixed in SP1
(8.1).
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Coming Soon: Pervasive DataExchange Training!


Barry van den Reek wrote:

Barry

Did you manage to resolve this issue. I am getting the same thing at my
client, but it only happens intermitently. Checking the pervasive log gave
me an error code which implied there was another engine running, different
version. This was the case, as they had brought a server over from another
(sub) company, which was running PVSW7 while there they have PVSW8.6. They
are going to uninstall PVSW fom the old server, and see if that works,
although we have been fighting with it for a while, and would like to find
out what the actual problem is ans some more detail about it. Any
suggestions would be great.