Q1) OK. Presumably, that's a one-time "thing" (and in any event the task is fairly complete now).
Q2) It's not surprising you saw this improvement, especially given the answer to Q3. It's now the case, that local is significantly faster than "over the wire" (even with a 100MBit network), due mainly to the difference in "packet size" (the amount of information transfere in a block). Over the wire, this is unlikely to be bigger than 1024 bytes at a chunk. Your hard disk may deliver 8-16K at a chunk, and Windows goes out and grabs even bigger "chunks" and loads them into RAM). If you are creating reports from data that does not have to be "up to the second", you are always better off working with a copy of yesterday's data. (Part of Softrak's nightly backup is to create a copy of our database for reporting only.)
Q3) In your planing, you might make a note to consider this. It will probably make a bigger difference to your overall "perceived performance" than any other purchase. Also, you should not consider giving general high-speed access to the internet until you have made this upgrade. People downloading videos and music from the web will bring your local traffic to a halt. (Not that people do that you understand
).
Q4) OK - If you need the statements rounded, the financial reporter includes a function to round numbers. You'll need to "fiddle" to figure out how to deal with the rounding error.
OK?
PS. If you're willing, I would be interested in looking at the statements that wouldn't convert. I'd need a copy of your whole g/l database though.