• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

ASP and VB6 speedup

i am running an standard exe using Wscript.shell. my Vb program accepts 2-5 parameters and connects to a remote database and downloads those tables from SQLserver. the parameters i pass are the table names. it will download the data and zip them and email the user as attachment and uploads these files to a ftp server using Inet object. Is there a way to speed up the process ? and how can i close the VB program if connection to remote database fails or data download is stuck or for some other reason. can anyone give me step by step code to do these optimization tasks and to speed up the entire process.plz help me the project is due today and i have everything ready but its running too slow.

I appreciate ur help in this regard
Thanks
Rama
0
ramakrishna1080
Asked:
ramakrishna1080
1 Solution
 
sybeCommented:
Which part of the procedure you follow is slow?
It sounds to me that getting data from a remote database is a slow process. If you have access to the server with the remote database, i would do the retrieval and zipping of data there.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now