Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008
    Posts
    2

    Unanswered: Question re. VB6, CR & SQL Server

    Need advise..

    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?

    Thank you.

  2. #2
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    That's hard to say without seeing any code...

    Have you run any timing tests to see where the time is being used?
    Lou
    使大吃一惊
    "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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •