You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Simple report but a lot of data and crashing

Received Response
10
Views
2
Comments
edited Jan 28, 2021 6:43PM in Reporting & Analytics for B2C Service 2 comments

Summary

report to show contacts who have emailed over the past year

Content

What is better - both options crash.

OPTION 1

Incidents table is root

Inner joining with Contacts to Incidents (800,000 incidents

Outer joining Org table to Contacts (1.3 million contacts)

OPTION 2

Contacts table is root (1.3 million contacts)

Inner joining with Incidents to Contacts (1.3 million contacts)

Outer joining Org table to Contacts 

 

My assumption is option 1 is better. Hard to explain to leadership the difficulty of not being able to run a years worth or 6 months worth of data.

Version

20A

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!