mgalloway

Slow Refresh Window with ODBC Connection

Discussion created by mgalloway on Oct 24, 2013
Latest reply on Nov 1, 2013 by mgalloway

This is my first question here in the forum, so please be patient with my lack of familiarity. I use FM Pro 11 and have a FM database connected to MS SQL Server pulling data from a series of 4 views. These views are added to my FM database as tables. There are not a lot of records in these views (ranging from 2300-10,500). but when I refresh window to get the latest data it is taking 5 minutes to completely refresh. I have tried using the script step in different combinations, but it does not help. Any ideas on what I may be doing wrong.

 

I have been working as a self taught developer for several years, but this is my first experience connecting to ODBC data sources.

 

Thanks in advance,

 

Mark

Outcomes