Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Not enough memory error because of the data model

Hi Everyone, 

 

I have two tables which are called Email and Blocks. Email has unique segment based deliveries and Blocks has more rows for each block email has. My issue is that I'm having trouble with a matrix visual which is not possible to display the visual because of the memory (even with 10 GB space in premium server). Dataset size is around 50 MB.

 

Email Table Structure:

245k rows and more columns than below

 

 

Blocks Table Structure:

800k rows and more columns than below

 

I use CommonKey to create relationship and I also have a Region and calendar table to map dates and regions. What I want to achieve is EmailTitle, Date, Country and Block Name based metrics as below:

 

 

But it gives me out of memory error and I think

 

 

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    If you have a dimension table for EmailTitle and a date table for Date and you use the columns from these dimension tables in your visual, then I wouldn't expect memory issues.

     

    In general, it's not a good idea to create relationships between fact tables like you've done here. I'd recommend removing that relationship and constructing your visual with dimension table columns instead.

2 Replies