General information
Category:
Coding, syntax & commands
Title:
Speed up processing for SQL pass thru
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only