Temp tables and performance

I have an issue here with performance on temporary defined tables.

I have a rather large table, which I due to some issues needs to load as temporary table.

While working with this large table I need to do a MODIFYALL on a field in the table. When NAV is executing this on MODIFYALL it's displaying "Modifying records in the xx table" and takes a long time...

My theory is that it's actually not putting the table into memory, but it's swapping it to the clients temp file.

If this is the case, then how can I:

1) Check if how much it's actually swapping

2) Extend the memory (we are running the clients under Citrix).

Parents Reply Children
No Data