General information
Title:
SQLEXEC and SQL statements are slow any solution
I am working on a program that calculates the business days excluding the weekends and holidays. There is a SQL statement that counts the number of holidays between the start date and the end date that excludes weekends. But this SQL statement is very slow. I mean it takes more than 80% of the time to execute the businessday function. The table it is accessing is a foxpro table.
Also, I am working on another prj that needs me to insert new records to a MS SQL server from FoxPro. I have the same problem with the insert to. It works but it is very slow takes more than 90% of the time to execute the function. If anyone has any suggestions or explantion on why it takes such a long time for a sql statement to execute that is connected to a SQL server please let me know. I have written the same thing where it connects to a FoxPro dbf table and the inserts and the select queries run faster than when i try to use them with a sql server.
I am using SQLSTRCONNECT to connect with the SQL server and SQLEXEC to excecute stored procedures and Inserts.
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