I have a view that is just under 12k rows long and is causing a 45 second sync time. The table is editable so making it read only is not an option. I already have a security filter that is reducing it down to around 8k rows but the table is also very wide at almost 50 columns. I have seen that data is pulled in parallel because a separate 13 second table read is not making the sync time 58 seconds its only just over the 45 second tables sync time. Could I separate this 12k row view into a couple of separate views to increase performance using the partition across many sources? If not any other tips to improve the performance would be appreciated.
LinkedIn
Twitter
