TDOLPHIN + MySQL - MY.INI

[MGA]

Using TDOLPHIN + MYSQL, I have a client that uses 5 networked computers. The client complains that the system sometimes stops responding. Would anyone have a MY.INI with the TIMEOUT ideas settings to help me?

[nageswaragunupudi]

Set wait_timeout to a higher value.

Just for information: FWH mysql automatically reconnects when needed.

[MGA]

Thank you very much for answering Mr. Nages.

Just for information: FWH mysql automatically reconnects when needed.

Mr. Nages, FWH would also reconnect when it loses INTERNAL NETWORK or INTERNET?

[nageswaragunupudi]

Mr. Nages, FWH would also reconnect when it loses INTERNAL NETWORK or INTERNET?

Yes in both cases. It makes one attempt to reconnect.
When the attempt to reconnect also fails then we get an error.

Even when the connection with the server is lost, we can continue to view, browse, sort, filter, print and do everything with the rowsets already open.

Whenever we try to write something to server or access server for new data, an automatic effort is made to re-connect to the server and execute the sql.

[MGA]

Mr. Nages, have you done any study on the effort required to migrate from TDOLPHIN to FWH MYSQL?

[nageswaragunupudi]

1) It should be very easy because FWMYSQL is extremely simple and easy to use. Does not even require much knowledge of SQL.
2) It is also not necessary to completely migrate the application to FWMYSQL to use its features. FWMYSQL can be used simultaneously along with TDolpin or ADO at the same time.

Connect to the same server with FWMYSQL also. The existing application continues to run with TDolphin.
When you add new modules and new functionality use FWMYSQL.
Slowly whenever you find time convert each module by module from Dolphin to FWMySql.
Both TDolphin ( or ADO) and FWMySql work at the same time comfortably.
Over a period you can complete the conversion.

[MGA]

Mr Nages,

with TDOLPHIN every 30 seconds I use a TIMER to execute a simple SELECT (eg SET @ dummy = 0)
to keep the connection active. With FWMySql this is necessary?

viewtopic.php?f=6&t=26207&p=144601&hilit=dummy#p144601

[vilian]

Sgs,

I made this migration from Tdolphin to FWMYSQL six months ago and it's exactly Mr Rao said.

In the begin I did two connexions with the server, one with TDolphin and a new with FWMYSQL, and new programs were writes using the new connexion, like Mr Rao said. But the resources of FWMYSQL for edit and browse files are so better than Tdolphin , and the migration so easy that we decided move everything for FWMYSQL imediately.

Nowadays we have a ERP with more than 400 prgs completely did with FWH/FWMYSQL and it's working very well.

Mr Rao is making a greate job !!

[nageswaragunupudi]

Mr Nages,

with TDOLPHIN every 30 seconds I use a TIMER to execute a simple SELECT (eg SET @ dummy = 0)
to keep the connection active. With FWMySql this is necessary?

viewtopic.php?f=6&t=26207&p=144601&hilit=dummy#p144601

It is not even necessary to keep the connection alive, because FWHMySql reconnects to server when necessary. (from FWH 16.12 onwards)
But it is desirable to keep the connection alive for better performance.

We suggest to keep the session alive not by keep using dummy select every 30 seconds, but by increasing the value of wait_timeout. You can do this either in the configuratin file or even easier in your program
oCn:wait_timeout := 30000 // or any value you like.

[MGA]

Vilian,

thank you very much for your clarifications, it encourages me to continue. Thank you my friend.

[MGA]

Simply fantastic Mr Nages,

I'm very excited to get started, congratulations on the fantastic work.