Deleting reports permanently
15 April, 2012
Can I permanently delete the reports from YF DB? Many of my users are playing around with the tool and creating 100s of draft/test reports. I want them to remove these reports permanently. Deleting the report does not remove it from the YF db - I am just concerned too many draft/test reports will increase the size of YF db and in future it might start impacting the performance. In the past I have observed that for many reporting tools querying metadata becomes very expensive due to large volume.
Thanks,
Rahul
Thanks,
Rahul
Hi Rahul,
Apoloiges for the delayed response.
We don't recommend removing data directly from the DB as this could cause issues across the entire install (e.g. delete a field that was used by multiple reports).
Generally reports don't actually take up much room in the DB.
It's only when you are caching views/filters that tables can get quite large, though once again, this does depend on the number of results you are caching .
Also it's worth noting that depending on your database, it could simply be a temporary DB or logging DB that could actually be blowing up in size.
Can you please find out if there are specific tables in your Yellowfin DB that are quite large?
Also, are you checking the entire DB size (which may include temporary DB files).
Regards,
David
Apoloiges for the delayed response.
We don't recommend removing data directly from the DB as this could cause issues across the entire install (e.g. delete a field that was used by multiple reports).
Generally reports don't actually take up much room in the DB.
It's only when you are caching views/filters that tables can get quite large, though once again, this does depend on the number of results you are caching .
Also it's worth noting that depending on your database, it could simply be a temporary DB or logging DB that could actually be blowing up in size.
Can you please find out if there are specific tables in your Yellowfin DB that are quite large?
Also, are you checking the entire DB size (which may include temporary DB files).
Regards,
David
Hi David,
My db size currently is not that large. I was just wondering if too many unwanted reports in the YF db would impact the performance overall. I understand you do not recommend hard deletes from the db and it makes sense. You can close this case.
Thanks,
Rahul
My db size currently is not that large. I was just wondering if too many unwanted reports in the YF db would impact the performance overall. I understand you do not recommend hard deletes from the db and it makes sense. You can close this case.
Thanks,
Rahul