Slow warehouse shipment on some clients...

BGI

We have a very strange problem at one of our clients site who uses SQL2005 and navision 5.0 SP1.
We use warehouse, and when looking at warehouse shipments, it takes several seconds to get the screen displayed or get the next shipment displayed.

Now the strange thing is that this does not happen on the server itself (sql2005) and it also does not happens on my portable. We just did a test with the same type of portable, but from the hardware supplier, installed the client 5.0 SP1, and it is also slow.....

What could be the difference between my portable and the other one? Cpu, disk, network all are the same. I have 4gb internal memory, the other only 2gb, but there is almost 1.5gb of free memory...

I cannot see what i have installed on my portable that is different from the other one, and still when doing exacly the same thing, mine is very fast, the other simply slow.....

Any suggestion is appreciated, because for the moment, i don't know at what i have to look .....

PS. Both use the same build of the client.....

kriki

I would start with the client monitor to check out if it is some SQL-statement that is slow.
Is the DB on both portables the same DB (This means restored from the SAME SQL BACKUP or detach/attach of the DB-files AND NOT a NAV-backup)?

BGI

We already used the client monitor, did on both machines the same thing. (they are both connecting to the same database on the same server).
Same command took a factor 10 on the slow machine compared to the fast machine, the results on screen are off course the same as its the same db.
Even if we did some tuning of the navision server, the slow machine is 10 times slower than the fast machine....

I don't have a clue what it could be.....

kriki

It could be that the slower machine has dirty statistics or the indexes are not been rebuild.
Try an File=>DB info=>tables=>optimize on both machines and retry.

BGI

I suppose the indexes and statistics are kept on the sql server and are for all the clients the same?
So if this is the case, both clients are using the same ?

kriki

Yes.

I thought each PC had it's DB locally.

Check the object cash of the client.
Check if there is some virus-scanner active.

infonote

Also check the firewall. A firewall may be blocking the program.