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).

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
 

 
Kelloggs
 
 

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!