# Roll up column stores values?

**URL:** <https://community.glideapps.com/t/roll-up-column-stores-values/7568>\
**Category:** Ask for Help\
**Created:** [April 22, 2020, 4:14am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568 "2020-04-22T04:14:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [April 22, 2020, 4:14am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/1 "2020-04-22T04:14:03Z")

</div>

Are values stored in Roll Up columns or … the rolling up process is done every time we show/need a roll-up column/value in the app???

So when there a lot of rows is it more efficient to roll up in intermediate categories?

Season-Category-Products

If I want to roll up balloon t shirts sold in Winter 20 season is more efficient in seasons sheets to roll up t shirts category values or it is better to roll up directly balloons t shirts ?  
Thanks

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [April 22, 2020, 4:33am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/2 "2020-04-22T04:33:25Z")

</div>

Why do you ask? Are you merely curious or is your app slow?

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [April 22, 2020, 7:56am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/3 "2020-04-22T07:56:48Z")

</div>

My app is slow. I have a lot of rows and I must increase efficiency.

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [April 22, 2020, 10:44am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/4 "2020-04-22T10:44:29Z")

</div>

Any suggestion?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 22, 2020, 10:55am UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/5 "2020-04-22T10:55:42Z")

</div>

If the app is running slow, it probably doesn’t have anything to do with the rollup column. Do you have other app functionality based on spreadsheet formulas?

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [April 22, 2020, 12:48pm UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/6 "2020-04-22T12:48:51Z")

</div>

Yes sure ! I have arrayformulas , querys lookup etc

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 22, 2020, 12:51pm UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/7 "2020-04-22T12:51:20Z")

</div>

Yep…all those formulas create lag in your app. Until November of this year, I relied on Google Sheet formulas to build my apps, but after discovering that they cause lag, I switched over to Glide data columns for relations/lookups whenever possible.

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [April 22, 2020, 12:56pm UTC](https://community.glideapps.com/t/roll-up-column-stores-values/7568/8 "2020-04-22T12:56:53Z")

</div>

Yes . Thanks Robert. Anyway would be good to know some tips to make apps more efficient as number of rows increase organically after publishing