Apex Code Development You need to sign in to do that
Don't have an account?
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,
Mike.
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,
Mike.
However, you can use "Selective SOQL queries" only when object has more than 100.000 records. See this: https://help.salesforce.com/HTViewSolution?id=000006007&language=en_US
Besides this, you should be fine.