I have a portal which is 'EXTREMELY' slow. It takes five minutes to load my results.
I am just comparing data which has the same postcode between a new Customer Table & an Old Customer Table.
Essentially just looking for duplicate records.
It look's for the using the Postcode as the matching field.
We have 130k customer records currently on our system.
The relationship is connecting the two tables but I really need to find a way to make this more efficient.
I have moved the portal onto it's own layout to ensure no other layout factors affect this.
Any ideas would be great.