Hi
I have a MySQL Database in a VPS Server , a Client program should connect to that remotely with IP address
The Problem is sometimes "Connect" process of TUniConnection and "Activating" TUniQuery takes long times ! , almost about 2 or 3 minutes !
There is No Blob Field in my SELECT statements and field counts are between 4 - 10
Client program have about 10 TUniQuery and 3 Connection without Blob Fields , but Initialization of client takes 2 - 3 minutes ( sometimes 10 minutes !! )
I know the Speed of connecting and Selecting depends on speed of my network , but in an usual network speed , 2 - 3 minutes is so long !
I want to know what configurations I should set in UniConnection and UniQuery to increase speed and performance ?
I have read the "Increasing Performance" section of help of UniDAC and tried many properties of TUniConnection and TUniQuery , but no chance !
Please don`t answer like "We cant produce the problem , please sent us an Sample Program ... "
Imagine you want to connect to an MySQL DataBase and Thres is about 10 Table with about 10 Field in each Table, and you dont have Blob Fields on SELECT statments , what properties and configuration you will set ?!
* All of INSERTs , UPDATEs, DELETEs and ... executes with a TUniSQL and Client don`t have any Local Database
This problem involved me of many days ! and I need your clear help
thanks a lot ...
Problem in remote connect to MySQL
Re: Problem in remote connect to MySQL
Such delays on connection to the server and query execution may be due to your MySQL server configuration, and this doesn't depend on UniDAC settings. Please check how long it takes to connect to the server and execute queries using the standard means, for example, MySQL Workbench. Use the same data of MySQL server and user credentials you used in UniDAC.