Duplicating ClientDataSets on a slow connection
Posted on 2008-11-08
I am using SQLConnection, SQLTable, DataSetProvider, ClientDataSet, DataSource method of displaying contents of a MySQL database on forms.
In some cases the same table needs to be viewed simultaneously (but displaying different Rows) using different DataSource's. The only way this seems to work for me is to use the same SQLConnection, but duplicate the SQLTable, DataSetProvider, ClientDataSet, DataSource components for each of the "Views".
The MySQL database is at a remote location - when activating these components it can take ten minutes to login due to the size of the tables that need to be made available for viewing. Once loaded speed of scrolling and searching is perfectly fine.
Is there anything I can do to speed up the loading process?