ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Problem Reports - Repeatable >> slow SO lookup in IN-A
http://www.istechforum.com/YaBB.pl?num=1233091548

Message started by MC-Eng on 01/27/09 at 14:25:48

Title: slow SO lookup in IN-A
Post by MC-Eng on 01/27/09 at 14:25:48

Running in EVO: IN-A, enter part number, push SO button, 36 seconds to bring up the open sales orders
Running in DBA: IN-A, enter part number, push SO button, instantly shows open sales orders

Server SBS2008, Xeon, 8GRam
Clients XP Pro, each min 2GRam
latest EVO and DBA

Any ideas? Can be reproduced at our 3 EVO seats.

Title: Re: slow SO lookup in IN-A
Post by deburr on 01/28/09 at 10:50:58

Mine works OK. Latest updates, but PTP network. I remember having a similar issue a couple of updates back and Allen fixed it. I just looked up the old post and it had to do with notes lookups and not sales order lookups.

Title: Re: slow SO lookup in IN-A
Post by gtladmin on 01/29/09 at 14:28:53

We are seeing the same thing in IN-A for sales orders--45 seconds. I reported it to Lynn, but I was thinking it was because I rebuilt the file. Maybe not?

Val

Title: Re: slow SO lookup in IN-A
Post by gtladmin on 02/13/09 at 09:52:06

Well, I just converted everyone back to the Classic views since the GUIs were aggravating everyone, and their complaining was getting to me. When they use the Classic view the look-ups come right up, no excessive waiting. So much for the GUI.

Title: Re: slow SO lookup in IN-A
Post by GasGiant on 02/13/09 at 10:00:28

We've had random users get stuck in long wait cycles before and it mostly traced back to anti-virus settings. Their anti-virus programs were scanning every program (.RUN / .RWN) before it ran. Telling the AV program to trust everything on the drive where Evo lives brought the times right down.

Title: Re: slow SO lookup in IN-A
Post by dashdown on 02/17/09 at 10:14:33

We've had the same problem from day 1 with T7ina. I've changed the setting on our anti-virus software and it didn't help.

Title: Re: slow SO lookup in IN-A
Post by gtladmin on 02/17/09 at 12:12:26

Ours have always been set to entirely skip the \ists folder on the local hard drive as well as the entire DBAMFG folder on the server. Those two places, any folders and subfolders and sub subfolders, are never touched via on access scanning, only scanned at night during the off-hours AV scan. This is not the issue for us, either. A good suggestion, though.

Title: Re: slow SO lookup in IN-A
Post by NovaZyg on 02/17/09 at 13:15:40

Val, and any others having slow lookups.. try taking a look at the ISDRILL file. this file should be blank or have just some current user drill down records in it. should never be more then 20 or so records. If it is then try initializing the file. We have had other users who get this file jammed up and it causes big slow downs... for me and most users the SO lookup in T7INA is less then 1 second. Anti Virus is also a possible slow down too, but does not seem to be so in your case.

;)

Title: Re: slow SO lookup in IN-A
Post by dashdown on 02/18/09 at 07:22:07

Nope. ISDRILL is not our problem. When I try to do a SO lookup from T7ina not only does it take forever but I usually get the infamous "Not Responding" message in the upper left corner.

Title: Re: slow SO lookup in IN-A
Post by gtladmin on 02/20/09 at 10:16:21

Yep, I checked those ISDRILL files per Lynn, they are all empty. I even ran an audit file for Lynn, which according to the file said it was only a couple of seconds (1 or 2) to do the lookup, but when you are sitting at our computers, it's muuuccchhhhh longer for a sales order lookup. All the other lookups do in fact take only a second or two seconds to show. So it's got to be something else.

The only thing I can think of is that we did modify the lookup grid to sort by estimated ship date prior to the update. That was working great until after we did the update, now it's incredibly slow. Maybe something to do with that grid, SOLINES? No other grids have been modified, before or after the update. Can I replace that with a non-modified one, then see if that makes the difference? If that takes it back to normal, then I can try making the est. ship date mod and see if that sticks. Just an idea?

Val

Title: Re: slow SO lookup in IN-A
Post by NovaZyg on 02/20/09 at 10:26:37

Wait, How are you changing the sort order? are you just moving the field to the first position.. that is not changing the actual sort order. can you send me a screen shot of your SOLINE grid in SU-A...

Title: Re: slow SO lookup in IN-A
Post by gtladmin on 02/25/09 at 11:23:32

Allen,

as per the thread http://www.istechforum.com/YaBB.pl?num=1229976877/3#3, I added the field to the grid. I'll send you a printscreen.... It was working pretty well prior to the update and then the rebuilding of the tables....

Val

Title: Re: slow SO lookup in IN-A
Post by deburr on 02/23/10 at 10:29:24

Just installed the latest update and now my lookups are very slow. Running windows 7 on workstation. Was instant before update, now 6 seconds which seems like a looong time. Any one else have this same issue?

Title: Re: slow SO lookup in IN-A
Post by RPCAdmin on 02/23/10 at 12:43:46

Always have had it......reindexing sometimes improves it slightly......but NO ONE has ever been able to answer the simple question clearly - why is the SO lookup on a Classic screen INSTANTANEOUS and on the T7 screen take 6-30 seconds, depending on what the state of the database files are. I don't know if I buy the virus checker answer - doesn't the virus checker check the same files (RWN or RUN) whether you are running classic or T7 screen? Maybe something to do with the way the grid lookups work in some installations???

Title: Re: slow SO lookup in IN-A
Post by deburr on 02/24/10 at 05:41:08

Well I don't know what was causing the delay, and I tried turning off the firewall and antivirus on the workstation with no change in the timing. Later in the day, I had to reboot the server to get rid of a user seat being used by someone that was not actually on the system (t7poa crash) and that brought the wait time back down to 2 seconds, about what it was before the update.

Title: Re: slow SO lookup in IN-A
Post by RPCAdmin on 03/01/10 at 08:02:12

On the same subject, perhaps someone could explain to me why on my PC, the wait time for SO is 9-10 seconds (bearable), while on the boss's PC, for the exact same item, the wait time is 30 seconds?!?!? :-?

Also, I know we have gone thru this before, but what are the tricks to improve this lag time, in terms of reindexing and other things (OTHER than archiving SO's which the boss is very resistant about).

Title: Re: slow SO, WU, Transactions lookup in IN-A T7
Post by Missy Burke on 08/10/15 at 10:30:36

I realize this is an old post, but I am having the same issue in IN-A, not only with SO lookups in IN-A, but also with Where Used and Transactions. Here are a couple things of note in my situation:

The BK module will return results instantly, whereas the T7 takes upwards of 10-20 seconds.
Running Evo directly on the server does not produce the lag; results are returned in a couple of seconds with the T7 module
It doesn't matter whether "Enable Opening Screen" is enabled or disabled, same lag.
We are on the 2014.1 version running Pervasive 10.
As mentioned by deburr, a reboot of the Evo Server will actually bring the displayed results time back down to two seconds or so.

Please share the solution if it's been discovered. Thanks.

Title: Re: slow SO lookup in IN-A
Post by Kelloggs on 08/10/15 at 17:17:34

Years ago, we had a similar situation.
As the day progressed and users started to log in, DBA/EVO started to really, really slow down.
It took up to 10 seconds or more to open, search, etc, etc any window, BK or EVO.
The only way to "speed up" DBA/EVO was to reboot the server.

It turned out to be the L1 and L2 cache Pervasive Settings.
It could help you... It is worth a try.

Check my post:

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

And if you need the best advice in town contact BetrieveBill !!!!
http://www.goldstarsoftware.com/

have fun

:D

Kelloggs

Title: Re: slow SO lookup in IN-A
Post by Missy Burke on 08/11/15 at 05:55:12

Thanks Kelloggs. I can certainly try that, though our symptoms are a little different. I got some additional feedback from users and they recall this seems to happen suddenly as opposed to gradually over a period of days or hours. Also of note are the BK modules remain near-instant, whereas T7 are s-l-o-w. Another user also noted a marked increase in access violations and internal stack errors that coincide with the slowness. I also noticed the memory use dropped from 70% to 40% after the reboot, ntdbsmgr64.exe being the culprit (we have 4G RAM on the server, which we'll upgrade in the next couple of weeks).

Title: Re: slow SO lookup in IN-A
Post by btaylor on 05/04/17 at 12:27:46

Has anyone out there had any luck in figuring this one out? It has come back to haunt me again. SO from IN-A has been taking forever to come up the last couple of weeks (50-60 seconds). As some previous posts have mentioned, this is not a gradual thing. Left one day and everything was fine (about a second to come up). Came in the next day and all of the sudden up to the 50-60 second wait. Same for all users, not just isolated users.

Tried all the usual tricks - archived another year worth of sales orders, stopped and restarted Pervasive engine, rebooted server, re-indexed BKARINVL, BKARHIVL, BKARINV, BKARHINV. Still nothing.

Like always, still instant in DBA.

Has anyone figured anything out that fixes this?

I'd really like to know how it can be absolutely perfectly functional one day and turn to absolute misery the next day just out of the blue!