Doug,
I have a data intensive process that combines two databases, one is about 2.8 gigs total and the other is about .7 gigs to a result of about 3.2 gigs. It's slogging all this over a 10mb ethernet and the process only takes 10 hours on a P2-350 class machine.
Like the others have said it's doubtful that their code is anywhere near optimized.
>I have been asked to look into finding a faster computer for a VFP system. Currently, it takes almost 2 days to run a task [multiple tables, up to 3 million records in some of the tables] on a dual pentium 500 Mhz. Does anyone know how much faster this might run on a SUN 5000? [I already asked about optimizing the code and they think they have done everything they can. I don't know anything about the system -- they just have to cut the processing time.]