General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
How can I boost up speed of SQL Servers As compare to Vfp
Hi!
I wrote a program in Visual FoxPro(VFP). This prgram fetches data from text file named 'capture.txt) one by one) ,parseed record to fields, converts fields to different data types and append this data in DBF table. It processes more than 70,000 records within 34 seconds.
Same code I written in SQL server T-Sql. It processed the same data within 5 Minutes. How can I boost up the speed of this process. (Note: The T-SQL procedure; I executed it from VFP. VFP fetches records(one by one) from the Capture.txt file and sends it to T-SQL Procedure in form of a parameter, rest of processing is done on SQL Server.)
Same procedure like VFP's ; from Visual Basic to SQL-Server took near about 9 minutes.
How can I boostup this data processing in SQL-Server so that data processing should be speedy.(near Visual FoxPro's speed minimum.)
Note: In SQL-SERVER I used TRUNCATE technique also, it reduced the processing time 5-10 seconds.
Note:In SQL-SERVER I left the step of (VFP)REQUERY(). REQUERY() Fetches fresh data from SQL-SERVER Table TO VFP table still.
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