TDOLPHIN + MySQL - MY.INI

TDOLPHIN + MySQL - MY.INI

Postby MGA » Sun Mar 12, 2017 12:09 pm

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?
ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá

Re: TDOLPHIN + MySQL - MY.INI

Postby nageswaragunupudi » Sun Mar 12, 2017 5:27 pm

Set wait_timeout to a higher value.

Just for information: FWH mysql automatically reconnects when needed.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10632
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: TDOLPHIN + MySQL - MY.INI

Postby MGA » Mon Mar 13, 2017 10:54 am

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?
ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá

Re: TDOLPHIN + MySQL - MY.INI

Postby nageswaragunupudi » Mon Mar 13, 2017 12:11 pm

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.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10632
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: TDOLPHIN + MySQL - MY.INI

Postby MGA » Mon Mar 13, 2017 12:44 pm

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

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá

Re: TDOLPHIN + MySQL - MY.INI

Postby nageswaragunupudi » Mon Mar 13, 2017 1:11 pm

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.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10632
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: TDOLPHIN + MySQL - MY.INI

Postby MGA » Mon Mar 13, 2017 2:36 pm

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
ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá

Re: TDOLPHIN + MySQL - MY.INI

Postby vilian » Mon Mar 13, 2017 2:41 pm

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 !!
Sds,
Vilian F. Arraes
vilian@vfatec.com.br
Belém-Pa-Brazil
User avatar
vilian
 
Posts: 975
Joined: Wed Nov 09, 2005 2:17 am
Location: Brazil

Re: TDOLPHIN + MySQL - MY.INI

Postby nageswaragunupudi » Mon Mar 13, 2017 2:55 pm

SGS wrote: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.
Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10632
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: TDOLPHIN + MySQL - MY.INI

Postby MGA » Mon Mar 13, 2017 3:51 pm

Vilian,

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

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá

Re: TDOLPHIN + MySQL - MY.INI

Postby MGA » Mon Mar 13, 2017 3:53 pm

Simply fantastic Mr Nages,

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

:D
ubiratanmga@gmail.com

FWH24.04
BCC7.3
HARBOUR3.2
xMate
Pelles´C
TDolphin
MGA
 
Posts: 1252
Joined: Mon Feb 25, 2008 2:54 pm
Location: Brasil/PR/Maringá


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: No registered users and 95 guests