|
-
August 9th, 2001, 09:55 PM
#1
Slow program
My program is tooo slowww. It uses a SQL server to update and load new data from the client and generate reports. How can make this faster.
I use SQL Server 2000,Windows NT and Visual Basic 6.0
cecile
The more u read, the more u do not know
-
August 10th, 2001, 07:15 AM
#2
Re: Slow program
how big is the database (datawise). also, if you are calling a query to update and load data, then that really depends on the size of the database/table. Moreover, it generates reports after updating/loading data - that may take some time (again, depending on the size of the database) It's just like running queries manually with a lot of data, which may take a long time.
[email protected]
-
August 10th, 2001, 07:19 AM
#3
Re: Slow program
With sqlserver, use of stored procedures may speed up.
Special thanks to Lothar "the Great" Haensler, Tom Archer, Chris Eastwood, TCartwright, Bruno Paris, Dr_Micahel
and all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
The Rater
...at present time, using mainly Net 4.0, Vs 2010
Special thanks to Lothar "the Great" Haensler, Chris Eastwood , dr_Michael, ClearCode, Iouri and
all the other wonderful people who made and make Codeguru a great place.
Come back soon, you Gurus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote
