Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can I boost up speed of SQL Servers As compare to Vfp
Message
De
05/09/2006 22:38:45
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Titre:
How can I boost up speed of SQL Servers As compare to Vfp
Divers
Thread ID:
01151185
Message ID:
01151185
Vues:
89
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform