paging file, as in your virtual memory? Find out how much memory your programs need at most, and set it to be equal to that amount minus your how much RAM you have. Depending on what OS you use there are a number of tools to track memory usage.
Overly large pagefiles really don't do any harm on NT OSes, but they don't help either. Aside from putting it on another partition like Tebore said, or, much preferred a totally separate drive on a different IDE channel, there's not much optimizing to be done
