Maxtrix form - loads slow with some users

anon2132

Hello,

Got a strange one here...

Same client (401 objects, 403 SQL Exe), license, cleared zup files, and same NAV permissions, same 'net type'.

However one user can open and view figures on the matrix form much quicker than others.

User1 = 1 second
User2 = 30 seconds

These are setup as database users.

Any pointers most welcome....

DaveT

Hi,

Have you tried the client monitor or SQL profiler to see where the bottleneck is?

anon2132

DaveT wrote:

Hi,

Have you tried the client monitor or SQL profiler to see where the bottleneck is?

I'm not really sure on how to do this, but if that is the next step, I'll find someone who can

Thanks

kapamarou

Just to make sure, when you say cleared ZUP file you mean that everything is the same.

So cache is the same in both users and also they haven't changed the view of the form (meaning that the smaller the cell in the matrix the more cells appear, the more calculations are performed)...

anon2132

kapamarou wrote:

Just to make sure, when you say cleared ZUP file you mean that everything is the same.

So cache is the same in both users and also they haven't changed the view of the form (meaning that the smaller the cell in the matrix the more cells appear, the more calculations are performed)...

Yes exactly...

DaveT

Hi

The client monitor is staightforward to use Tools -> Client Monitor and press start. Run the matrix form and then stop the client monitor and compare the two output to see where the delay is.

kine

But if you are not partner, you need additional granule in your license to be able to run the Client Monitor. But because you are using MS SQL, you can use the SQL profiler for looking for more details...

garak

Check also with the SQL Profiler.
It's under Start -> Programs -> SQL 20005 -> Perfomance -> SQL Profiler.

In the SQL profiler you activate following Events

Showplan XML (to see which index is used and if he scan or seek)

Stored Procedures
- PRC:Completed
- SP:Completed
- SP:StmtCompleted

TSQL
- SQL:BatchCompleted
- SQL:BatchStarting

Filter:
Session -> the Sessionid of the user to see only the activity of the user or
Reads -> over 5000 //view all Reads over 5000 pr
Duration -> 2000 ms //view all processes over 2seconds

Do you use indexhint or recompile?

Regards