InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 03:08:53 GMT20http://forum.strataframe.net/FindPost16993.aspxHi All,<P>What setup can cause the Save to take too long at least at the first time. Using maintenance forms with one or 2 tables I see this problem. I can have a table like Credit Card Type with 4 records and the Save took 8 seconds the first time. The second time it is instantly.</P><P>Regards,</P><P>DoronThu, 12 Jun 2008 14:18:29 GMTDoron Farberhttp://forum.strataframe.net/FindPost17027.aspxHi Trent,</P><P>Thanks for your reply. </P><P>Regards,</P><P>DoronThu, 12 Jun 2008 14:18:29 GMTDoron Farberhttp://forum.strataframe.net/FindPost17005.aspxThis is kindof like asking, "how long is a string."&nbsp; There are a lot of reasons, most of which comes from the server and connection setup.&nbsp; This is especially common when a VPN is in the mix, talking to a web service, etc.&nbsp; This can also happen based on how a SQL Server is setup.&nbsp; This is not something I can give you a straight answer for, but I can tell you that you will want to look more in the direction of your configuration versus within the framework.&nbsp; It sounds like the network connection is being established that first time, and any subsequent update (within a shorter given period of time) isn't having to deal with that same barrier.</P><P>If it were me, I would work backwards.&nbsp; I would create a simple test app that just creates an SqlConnection, and determine if the bottleneck is at the time of the initial connection being created or something else.&nbsp; This might even call for a packet sniffer if you can't pinpoint where the slowness is coming from.Wed, 11 Jun 2008 22:20:45 GMTTrent L. Taylor