I am working with vfp8 on a win2k machine.

I have a DLL which a C program calls and passes in a string that contains all the info to be entered in the SQL server table – table name is noted in the string.
The programs I have built chops up the string into the pieces needed to figure out what table it goes into, and what action is being done to the table – add, change or delete record - I do not do a change, I delete that record and add it again. Some table actions require other tables to be changed also at that time – my code knows which ones.
The problem is that my code takes more then twice as long as the code for just straight vfp code – one table went from 1.1 minutes to 5.03 minutes, another went from 7 seconds to 30 seconds.
I have no DO WHILE loops in the programs. I have a lot of CASE statements and IF statements. I prep the data, split out the items needed from the string in one program, then call the next program that does the actual insert and/or delete in the tables as needed.

Is this enough info for someone to help me, or should I put some of the code out?

Thanks in advance.
Beth