I'm not noticing any kind of speed issue when I save. Do you belive I'll notice degredation once a few hundered people are connecting and disconnecting? I don't think I'll put it to the test, but I am curious.
Regards
Jeff
>If you are not collecting login information for the user to create the connection, I would still create the connection at startup. I would definitely NOT continually connect and disconnect before and after an update. That is too much of a performance hit for me. I would connect if needed, but not disconnect until the user quits the app.
>
>>I usally open a connection at app startup then disconnect at app close. But I'm working on an app where most users don't need a connection. Only a small handful of users that are inserting and updating to SQL need a connection. Question: "Would it be detrimental to Connect right before insert or update then immeditaly disconnect?". Just a note, this app updates SQL for another app. Most users update and read Fox tables.
>>
>>Your opinion is appreciated.
>>Regards
>>Jeff Hart
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only