Limitations on view
Answered
Hi,
Can you please let me know is there any limit on the number of tables I can have while creating a view for report?
Hi,
Can you please let me know is there any limit on the number of tables I can have while creating a view for report?
Hi Sagar,
While we do not have a hard number available, and I dont have an excellent setup to test on, my belief is that there is no limit on this. I have personally seen clients with up to 100 tables in a view.
However, adding too many tables should be avoided unless entirely necessary. For both performance, as well as future maintenance and expansion, it is best to keep the view as simple as possible.
Is there a reason why you need so many tables?
Regards,
Nathan
Hi Sagar,
While we do not have a hard number available, and I dont have an excellent setup to test on, my belief is that there is no limit on this. I have personally seen clients with up to 100 tables in a view.
However, adding too many tables should be avoided unless entirely necessary. For both performance, as well as future maintenance and expansion, it is best to keep the view as simple as possible.
Is there a reason why you need so many tables?
Regards,
Nathan
Hi Sagar,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Hi Sagar,
I am going to set this ticket to closed for now, but if there is anything else I can do to help here, please just let me know and the case will be re-opened!
Regards,
Nathan
Replies have been locked on this page!