Multi Access on Multi Core?

[FM Newbie]

I have FMP 10Adv newly loaded on a Windows Server 2003 with 4 cores, 4 GB, and 1.8 GHz per core. I access the system with Remote Desktop.

I am running a table migration script against a table of 160,000 rows and 79 fields, migrating to 7 different tables with a variety of rules and calculated conversions.

FMP seems to be only using about 50MB with a total of 800 MB in use (nothing else really going on, except a couple of IE windows open, but not used).

It looks like this will run about 16 hours (note: after 40,000 records and 8 hours, I figured out to turn on Freeze Window ... so I am expecting an improvement)

Here's the thing: The CPU is running at about 25% ... which, I assume is all the solution can muster (whether it is disk bound [doubt] or just can't use more than 1 core, I am not sure)

I thought I would try to do some script development work while this is crunching, but I cannot seem to do anything else in FMP while this is running.

Is there a way to start another instance -- or some other solution?

(Note: I would also be interested in any system tuning performance tips overall, since this solution will eventually have many more records in the tables)

[fseipel]

You can try downloading a demo of FMP; that will allow you to run another session when logged in as another user under WS2003 until the trial expires; unfortunately, if you don't have another FMP license, you can't run another session. You used to be able to run more than one FM instance as the same user, for different versions (e.g. an 8.5, a 9.0 Advanced, could run at once). This might cause stability problems and has the disadvantage of not allowing use of all 10's features so is not preferred.

If the script can be converted to a scheduled script it can run on the server without the client, though not all scripts can run on the server.

If the script is taking this long and can't be optimized, it may be worth looking at another backend.

[Steven H. Blackwell]

Why are you running FileMaker Pro on the server OS? You aren't running both FileMaker Pro and FileMaker Server at the same time on the same machine, are you?

Steven