Server side processing:
We used the server side approach of datatables.net automatically for every datatable representation of data.
Not only we use a “limit” and “offset” in the query, we also provide filters and search, call it selectors in the following text.
How does it work:
Technically we process two queries. The first query us the amount of data # of tuples, pages etc, with current selector. The second query returns the data, including subqueries.
Subtable Search:
We only transfer the “paged” data to the client, an also do not build the full “tree” of data, so if we want to do a search inclouding the linked touples, this is not possible.
If we want to use a search through the subtable the query has do all joins first, and then selecting the data.
The next step is, if we search like a phrase, we only what to have tuples containing the search phrase. But in the subtable context, if a subtable entry matches, we want all subtableentries.
=> TODO FIND A GOOD EXAMPLE.