[Samba] What makes excel file opening so slow??

[Gaiseric Vandal]

Can you set Excel to use the local drive for the temporary files?  By
default, MS Office creates temporary files in the same directory as
the original file.   In the past, troubleshooting a LAN related issue,
it seemed that when saving a file, excel would rewrite the entire file
to a new file then delete the old file, while Word would just update
the same file.  My guess is that Excel also creates much bigger
temporary files.




On 5/31/07, Chan Jason <jason.polaris at gmail.com> wrote:
> Hi list,
>  Despite the question I asked last time (I will re-install the FC3
> with Samba 3.0.14a on another computer for replacement soon), I still
> have one more question on Excel files. I found that Excel file opening
> is extremely slow (especially on slow connections, i.e. VPN). The case
> is really bad, it takes around 2 mins to open a excel file of around
> 400k. Actually we got both side having 4M/4M DSL line. One side is
> Hong Kong, and the other side is China. However if we build a VPN
> inside Hong Kong, it takes 10~20 seconds to open a 400k excel file.
> However if I just copy a 400k file, neither of them take such a long
> time. Both situation can finish the transmission within some seconds.
> So what is so special about opening a excel file, and how can I
> improve the speed? Thanks for comments!
>
> Yours sincerely,
> Jason Chan
> --
> To unsubscribe from this list go to the following URL and read the
> instructions:  https://lists.samba.org/mailman/listinfo/samba
>