I have made a program in VB6 and integrated Crystal Report using SQL Server (wireless connection). The database has 6 tables and presently one of the table has approximately 7000 records. All tables are all indexed.
One of the function of the program is to be able to print label packages. My problem is that the printing of 1 label takes about 8 seconds and 5 labels take 45 seconds, in which the users are finding it very slow.
Any advise please on how to speed up the printing process. Does calling Crystal Report makes the printing slow? Or wireless connection is the culprit?
Have you run any timing tests to see where the time is being used?
"Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
"I have my standards. They may be low, but I have them!" - Bette Middler
"It's a book about a Spanish guy named Manual. You should read it." - Dilbert