da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Efficient remote connection to MySQL

Forum List » AnyDAC » v 1.x General English

ctiberg
User

Fresh Boarder

Posts: 8

Karma: 0

Efficient remote connection to MySQL

Posted: 2007/09/28 03:23

Hello!

I've tried to connect to a MySQL server over the Internet, and it wasn't fast. At all. What's the settings in the TADConnection to use for maximum performance without regard for hogging bandwidth? I've already turned on compression in the Params section, btw.

Diman

Admin

Posts: 1473

Karma: 18

Re:Efficient remote connection to MySQL

Posted: 2007/09/28 03:36

Hello

1) Turn off metadata fetching, by excluding fiMeta from FetchOptions.Items.
2) Try to set ResultMode to Use.
3) Use in SELECT list only really needed columns. Try to avoid to fetch long fields.

Regards,
Dmitry

ctiberg
User

Fresh Boarder

Posts: 8

Karma: 0

Re:Efficient remote connection to MySQL

Posted: 2007/09/28 07:19

Well, my only problem now is that I don't get all records - just a subset. What causes that?

Diman

Admin

Posts: 1473

Karma: 18

Re:Efficient remote connection to MySQL

Posted: 2007/09/28 07:55

I thin ResultMode=Use. Try to remove it.

Forum List » AnyDAC » v 1.x General English