AnsweredAssumed Answered

Ways to speed up a portal.

Question asked by craig157 on Mar 19, 2018
Latest reply on Mar 19, 2018 by FileKraft

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.

 

Thanks,

Outcomes