#1474 closed enhancement (fixed)
Exporting raw data with TableExporter is slow if reporter column are included
| Reported by: | Nicklas Nordborg | Owned by: | Nicklas Nordborg |
|---|---|---|---|
| Priority: | minor | Milestone: | BASE 2.15 |
| Component: | web | Version: | |
| Keywords: | Cc: |
Description
The table exporter is very slow when exporting raw data and the user has selected to export reporter columns. The reason is that the main query is only loading the raw data. The associated reporters are loaded one by one which takes a long time when the data set is large. On my development machine a data set with 36K entries takes about 4 minutes to export.
The fix is to include a "fetch join reporters" in the query. This is already done in the query for the list page.
Change History (5)
comment:1 by , 14 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:2 by , 14 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
comment:4 by , 14 years ago
(In [5296]) References #1474: Exporting raw data with TableExporter is slow if reporter column are included
There was a similar issue with reporter lists.
comment:5 by , 14 years ago
(In [5297]) References #1474: Exporting raw data with TableExporter is slow if reporter column are included
It should of course be a 'fetch join'.
(In [5294]) Fixes #1474: Exporting raw data with TableExporter is slow if reporter column are included