Results 1 to 2 of 2

Thread: file import

  1. #1
    Join Date
    Jun 2008
    Posts
    2

    Unanswered: file import

    have a question about building stored procedures in Pervasive. I use Pervasive with an accounting application and need to build a new Crystal Report. I have bulit the report using an ODBC connection to Pervasive and unfortunately have run into some serious performance issues. I am confident that the performance issue is not in the query since I am running the same query in MS Access (linked tables) and it is processing in a matter of seconds.

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    Stored Procedures won't help. Stored Procedures don't normally gain any performance over standard queries. If the query is fast when using linked tables in Access but slow in Crystal, it may be a Crystal issue. Is the query fast if you use Pervasive Control Center? Also, make sure you're using ODBC through Crystal and not the Btrieve driver.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

Posting Permissions

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