Database is served of FM Server 8, the problem I'm having is when I use Import Records script to simply copy data from one table into another table (some 500 records) within the same FM file it takes soooo long! It takes longer than original import from an excel sheet into the table, but excel sheet comes from the client machine so it has to upload it to the server where both tables mentioned before reside on the server within the same file and it still takes much longer...why is this so slow? How can I make this faster? Would it be faster if I used FM Server 8 Advanced over HTTP (perhaps then all the processing will be done on the server side?)

Whilst the data may actually live on the same machine and in the same file I think the data is being delivered from the server upto the client, and then the client sends it back to the server.