Richard,
This is definitely one of the problems I'm facing with the RB MySQL
plugin. Without more extensive documentation of the how the MySQL
plugin connections work, I can't establish what will be a workable
application behavior model except through some experimentation in RB.
The timeout variables in the MySQL database I'm connecting to don't
seem to reflect the actual behavior I see in the the use of an
always-open MySQL database connection in RB. My choice of no more than
5 minutes of an idle connection actually appears to be good choice,
because I've found if I don't refresh the connection at that point,
accessing the open database connection crashes the app at the
executable level and the app crashlog shows what appears to be another
crash in the plugin code. I'm hoping to experiment a bit more with the
settings on the MySQL side and what I'm doing on the RB side and see if
I can establish a relationship between the two, though.
Thanks for the advice!
-Dave
On Thursday, March 27, 2003, at 09:58 AM, Richard Altenburg wrote:
On 27-03-2003 08:26, "Dave Slack" <nospam at forestdigital dot com> wrote:
Thanks for the feedback, it's much appreciated. I'm thinking 14 hours
might be a bit long :-) but I might try lengthening the timeout I'm
using to 15 or 30 minutes and see how things work out. Without more
specific knowledge of how the RB MySQL plugin works in interaction
with
MySQL DBs or what RB's MySQLDatabase.connect actually does, I'll just
And maybe someone sets the MYSQL_OPT_CONNECT_TIMEOUT to a value of 5
minutes, and then that is your timeout. I do not know if the plug-in
sets
this value for the connection it opens, but I do know that if it does,
RS
should publish this value. And, I guess you can set this value using
SQL,
because it is recognized by MySQL. Or can this only be set at the
Internet
provider's side? Anyhow, someone could set it, so you cannot rely on
your
own tests with a specific provider I think.
---
A searchable archive of this list is available at:
<http://support.realsoftware.com/listarchives/search.php>
Unsubscribe:
<mailto:realbasic-nug-off at lists dot realsoftware dot com>
Subscribe to the digest:
<mailto:realbasic-nug-digest at lists dot realsoftware dot com>
.
|