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.
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