|Full Synchronization Terminates Due to the Timeout / Optimizing the Runtime of an Offline Dataset|
A dataset determines all data in an info area that either is included in one of the filters specified in the dataset or is linked to at least one of the specified child records.
These conditions are included in a single SQL statement. In addition, the conditions and dependencies defined in child datasets as well as the access rights defined for all involved info areas are also included in this statement.
Combining child datasets and/or access rights definitions often results in complex database requests (which take a long time to execute).
Using filters instead of dependencies result in simpler SQL statements. Depending on the data volume you can also export all records the user is only allowed to view.