Slow program

[CecileR]

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

[enigmaos]

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.

enigmaos@yahoo.com

[Cimperiali]

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