Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: CR slow when adding new tables to a connection

    I can't understand what's going on with Crystal Reports.
    I'm doing something that should be simple and very quick, but it takes ages in reality.

    Here's my problem:

    I am simply adding a new table to my database definition (an ODBC connection to a MySQL database). When I select the tables, Crystal Reports is doing a "SHOW FIELDS" for that table (OK) and then a "SELECT (list of fields) FROM tablename" which is obviously taking ages since those tables have millions of records and are as huge as 4Gb of data (many blobs and text fields).

    Is there a way to tell Crystal Reports not to do a full query of the whole table? What's the point in executing that query at this stage when there's still no formulas or reports defined?

    Imagine my workstation that's first waiting for a very slow query to perform and then transfers every result through the LAN and tries to load 4Gb of raw data into something structured and then dies painfully

    Please help!


  2. #2
    Join Date
    Jan 2004
    Jersey, UK
    Well this is a complete guess, so don't laugh, but could it be that you have the option to 'Save Data with Report' turned on? It's in the File menu. I'm guessing that if you do, the report tries to compile the data before it runs (or something like that).

    Regards - Andy

Posting Permissions

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