function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Mike ArthurMike Arthur 

Anyone have experience of working with an object with 1m rows?

The requirement is to show the UK parliamentary constituency based on the postcode of an account.  Using a custom object to store the constituency for each postcode would result in pretty close to 1 million rows.

1 - Can anyone share experience of working with an object on this scale?  What kind of performance impact may be expected?  Any data loading challenges?

2 - It feels like Apex would be needed to populate an Account 'Constituency' field based on the postcode.  Anyone have any alternative suggestions?

There are other considerations such as the impact on the data volume usage and what happens when boundaries are changed, but just looking to see if this is worth considering further.

Many Thanks,
Tadeas BTadeas B
There shouldn't be any significant impact if you write your code right.

However, you can use "Selective SOQL queries" only when object has more than 100.000 records. See this:

Besides this, you should be fine.