What is the best way to transmit data?

Question

C++ / C#

Good afternoon!
A big request to advise in what form is the best way to transfer data through WCF.
It is necessary to transfer the following information:
- 1 table from the database (MySQL), 5 columns and almost 10 thousand records.
- Pivot table consisting of 3 database tables (MySQL), 18 columns with 7-9 records for each record from 1 table.
How the application works:
The client displays table 1 in the main window, when opening a record, detailed information is displayed.
Initial version: The
class was compiled on the server side and then sent to the client.
All other manipulations were carried out only with the received class without additional requests to the server.
Disadvantages:
Long class generation on the server side
New option:
Transferring the first table with 10 thousand records in the DataTable format - a significant increase in the speed of sending to the client
An additional request to the server for clarifying information on each individual record (getting a pivot table in the class format) is generated every time the record is viewed.
Question:
Is there a better solution to this problem?

Answer 1

You can implement pagination. You can try to use the binary transfer format - compress the data. You can - do something like slicing https://msdn.microsoft.com/en-us/library/aa717050.aspx
PS A variant with transferring a lightweight data set, which is only needed for output to a table and loading data by record details - also fine.