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)

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.