Windows application connecting MySql through Internet

[Zsolt Csillag]

Hello,

I would like to make an application in Delphi 2006 that connects to an Internet MySql database.

So as to be faster I thought of loading the data as needed.
For example at first start the customer can see only the first 20 row.
Then clicking on a button he can see the next 20. At this point he should be able to go back 20, or go forward 20 records.

Any idea how to do this efficiently? I think I should use the "limit" command somehow.
Other procedures how to reduce the netword traffic are welcome

Thank you in advance!

[Antaeus]

You should set the FetchAll property of your dataset (TMyQuery/TMyTable) to False, and FetchRows to 20.
You can read more about these properties in the MyDAC help.