ISTech Support Forum - DBA Classic slow to pull up screens

Welcome, Guest. Please Login.

	05/09/25 at 04:22:35 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Problem Reports - Repeatable

‹ Previous topic | Next topic ›

Pages: 1

DBA Classic slow to pull up screens (Read 2762 times)

sunmfg

Member

Posts: 59

DBA Classic slow to pull up screens
10/30/13 at 15:47:05

We run dba classic on a peer to peer network, with dba program loaded on a stand-alone machine.
The program performs OK when I first start it, but within about an hour it starts to slow every time I access a list, such as IN-A, SO-A, etc. By the end of the day I hit IN-A and I have a blank screen for about 30 seconds before it loads. No one else is having this problem. I have killed unnecessary start up routines, ran a registry fixer, and scanned for viruses. No change.

Any ideas?

IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: DBA Classic slow to pull up screens
Reply #1 - 10/31/13 at 07:05:40

"No one else is having this problem"???
Do you have more than one computer running dba?
Only one has performance issues?
I dont get it.

When DBA slowdowns as the day progresses. It is because the Pervasive Engine (ntdbsmgr) needs more memory or its memory settings need to be adjust.

http://cs.pervasive.com/forums/p/15005/52497.aspx#52497

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

sunmfg Member Posts: 59	Re: DBA Classic slow to pull up screens Reply #2 - 10/31/13 at 07:22:32 Kellogs, There are 2 heavy users and 2 occasional users besides myself using dba on this peer to peer network. I am the only one having these issues. Given that, I'm not sure the discussion in the link you provided will apply to me. Thanks, Wayne
Back to top	IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: DBA Classic slow to pull up screens Reply #3 - 10/31/13 at 07:59:25 The idea still relevant for a workstation. You should monitor your w3dbsmgr (Task Manager) If your dba slow downs, the pervasive engine does not have enough memory and has to relay on the page file. Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

sunmfg Member Posts: 59	Re: DBA Classic slow to pull up screens Reply #4 - 10/31/13 at 08:21:12 OK, I put dba and task manager windows up side by side and clicked on IN-A. During the 18 seconds it took for the inventory screen to come up, w3dbsmgr started at 15,052k and never changed during the process.
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: DBA Classic slow to pull up screens
Reply #5 - 10/31/13 at 09:38:05

The w3dbsmgr will not change, if it got as far as it can get. it will not decrease either, unless you reboot your computer.

I did some testing the highest we got was 11,100K
On a machine with 8GB of memory with the pervasive cache allocation of 64 MB and memory usage of 60

I assume that pervasive is installed as a service right?

This is what I would do.
I would remove pervasive, run a register cleaner, reboot the pc and install it again with all the service packs.
It will take you no more than 15 minutes.

It might help

embarrassed

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

sunmfg Member Posts: 59	Re: DBA Classic slow to pull up screens Reply #6 - 10/31/13 at 09:54:07 And you are referring to just my PC, not the dba box, right?
Back to top	IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 784 Gender:	Re: DBA Classic slow to pull up screens Reply #7 - 10/31/13 at 10:01:53 Yes, assuming that your machine is just a "client" by the way what pervasive are you using?? we had some issues and after the services packs we saw a increase in speed but beware both the server "dba box" and the client should have the same pervasive version and service packs!! Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

sunmfg Member Posts: 59	Re: DBA Classic slow to pull up screens Reply #8 - 10/31/13 at 11:22:43 We are using Pervasive 11, workgroup version. We had to go with that when the dba box was replaced with a Win 7 machine. All the workstations have that version installed. I'm not aware of any updates since it was installed. Mine reads Pervasive 11.20, 11.20.015.000.
Back to top	IP Logged

sunmfg Member Posts: 59	Re: DBA Classic slow to pull up screens Reply #9 - 11/05/13 at 08:38:58 Kellogs, I tried to uninstall Pervasive so I could reinstall it, but pervasive is not showing in my add/remove programs list. It shows up in the other workstations, but not mine. Maybe that is a sypmton of my problem? How do I do a clean uninstall if it is not listed in add/remove?
Back to top	IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 784
Gender: male

Re: DBA Classic slow to pull up screens
Reply #10 - 11/05/13 at 09:07:12

Yeah that is a problem!!!

Quote:

You may have to manually remove all elements from C:\PVSW, as well as the C:\ProgramData\Pervasive Software and C:\Program Files\Pervasive Software and C:\Program Files (x86)\Pervasive Software, then blow away anything from the registry under HKLM\Software\Pervasive Software, too. After that, reboot, and it should install cleanly.

But if removing it from the register does not fix the problem. You will have to reinstall your entire Windows. I would contact

http://www.goldstarsoftware.com/ if I were you
or post a question on the Pervasive Forum http://cs.pervasive.com/forums/

undecided

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Problem Reports - Repeatable

‹ Previous topic | Next topic ›