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
Printable View
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
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]
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