Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007

    Unanswered: Universe DB issues

    I need to pull data from an Accounting system (Total Return) which uses Universe database to store data. I use sql queries to query the db via ODBC connection. The code is written in C#.NET.

    However, the queries run very slowly-- it takes hours to get data of a few thousands of records. What's worse, the sql queries tie up the system for hours so the Accounting people cannot enter data into the system.

    Any suggestions on how to resolve the issue will be much appreciated.

  2. #2
    Join Date
    Jun 2004
    Arizona, USA
    Perhaps this link would help (in assuring that the connection is set up properly)
    "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

  3. #3
    Join Date
    Oct 2007

    universe issues

    thanks, loquin. Unfortunately, the odbc connection came with application package. I'm not sure if I can access the configuration. The support staff of vendor (SS&C) seems not to be helpful.

Posting Permissions

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