Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I boost up speed of SQL Servers As compare to Vf
Message
From
08/09/2006 01:55:10
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
01151185
Message ID:
01152169
Views:
39
Thank u v much Sir!
Using SQL000 Personnel Edition Despite SQL7.0 and using BCP or Bulk INSERT; Processing speed increased. Now delay time decreased from 5 minutes to 1 minute approx. But there another problem increased; I can't use Bulk INSERT or BCP to fetch data from capture.txt file while caputre.txt file is opened in Hyper Terminal.
To solve this problem I used xp_cmdshell to copy file from Capture.txt to Capture2.txt
and then fetch data from capture2.txt using BCP
but result is average processing time increased. Kindly guide me how can I fetch data directcly from a text file that is opened in HyperTerminal. In VFP and VB I can open this file in READONLY mode.(vfp fopen())(VB OPEN).
Thanks alot again!

Naeem
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform