MySQL in VPS

[cybsistemas]

I have to make a program that works with a MySQL database that is on a VPS server.
How do I gain speed. ? (tips)
Version MyDac 7.6.12

[AndreyZ]

To improve the performance of data fetching in MyDAC, we suggest you to set the following options:
1. TMyQuery.ReadOnly to True (in case if you do not need to modify data).
2. TMyCQuery.FetchAll to True. In this case all data will be fetched to the client at once.
3. TMyQuery.FetchRows to a value that gives the most data fetching speed on your network (it is individual for each network). FetchRows affects only data fetching speed.

[cybsistemas]

Thanks

[AndreyZ]

You are welcome.