April 1, 2009 at 6:07 am
We are currently using an ODBC connection between our Progress and SQL databases. It's too slow for real-time queries so we usually refresh a SQL table from Progress at night when the load is lower. Can someone recommend a better solution? I am a newbie in this area so please explain in detail or provide a link to a page that does so.
Thank you very much.
April 1, 2009 at 10:42 am
Hi
This is a little less information to help.
* What does your progress? Show data? Update data?
* How many data does it handle?
* Which statement(s) do you use?
Greets
Flo
April 1, 2009 at 11:31 am
Use SSIS to extract/load data instead of using linked server (is that what you are using?).
Other options:
Create procedures in Progress, call procedures through linked server instead of queries.
Create views in Progress to limit data, use views from SQL Server instead of tables.
Make sure queries on tables in Progress have SARGABLE where clauses to avoid pulling all data across the linked server.
There could be any number of additional options to help - but, it really depends on what you are trying to accomplish.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply