This sounds like a typical network latency issue when connecting remotely (WAN) to a data source, FM or ODBC.
It's also possible that the number of views of your ODBC tables may be slowing the cache process on the network.
What is your network connection to your ODBC source(s). Is any WAN connection involved, or is everything on your local wired network?
Thanks for the input. I have worked out a solution by reducing the number of fields on my view pulling to the list layout that only showed a few of those fields. Once we created a new view specifically for the list layout with only the fields we needed for that list it refreshed much faster.
I have been developing Filemaker databases for many years, but this is my first experience with connecting to SQL views/tables through ODBC connections. Needless to say I have learned a lot.
Your information was very helpful to me. Thank you very much.