time lag between menus in mfg/pro eB2

S

sreekuax

Member
Hi all,

Recently we added a new instace to our existing eB2 application. But the problem with the new instance is , when we type menu number say - 1.4.1 (or any other menu #) the time taking to show up that screen is 10-12 secs which is irritating. While in other existing instances the time lag is 1-2 secs. Can anyone tell me what we have to look to correct this time lag. The issue is not only with 1.4.1 but with all other menus.

Pleas help ASAP.
 
I think that a possible cause could be the lua_det. Its a hidden feature from qad. This table contains all combinations of userid, license and number of accesses.

Which service-pack is installed?

William
 
William,

Do u meant to say that lua_det is not there in newly created instance, or if existing in new then we have to load that table contents from other instance to new instance ?

by the way the version is eB2 with SP 8.
 
Sorry for the delay.
The Lua_det is a system table used by QAD to monitor the behaviour of the MFG users in relation to the licensed programs. The table can only be cleaned after a License Audit.

The data stored are the licensed application, userid, sessionid, program started, startup-date and time. It also contains the number of times the program is used.
If the table is to full it leads to funny behaviour of starting up any program.
The information is stored independant if a program has been added to a menu or not.

Try the following query in the Progress Editor.

The number of total records
SELECT COUNT(*) FROM lua_det.

Another one is total per product:

SELECT lua_product, COUNT(*) FROM lua_det
GROUP BY lua_product.

Sent me the information via private message please.

Gr.
William W.
 
You must log in or register to reply here.
Back
Top