# Transforming large datasets eating too much memory

**URL:** <https://forum.inductiveautomation.com/t/transforming-large-datasets-eating-too-much-memory/77715>\
**Category:** Ignition\
**Tags:** vision, database, perspective\
**Created:** [August 10, 2023, 6:47pm UTC](https://forum.inductiveautomation.com/t/transforming-large-datasets-eating-too-much-memory/77715 "2023-08-10T18:47:57Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Derick\_Lawrie](https://avatars.discourse-cdn.com/v4/letter/d/bb73d2/32.png) [@Derick\_Lawrie](https://forum.inductiveautomation.com/u/Derick_Lawrie)\
**Post date:** [August 14, 2023, 2:15pm UTC](https://forum.inductiveautomation.com/t/transforming-large-datasets-eating-too-much-memory/77715/6 "2023-08-14T14:15:12Z")

</div>

Hi everyone thanks for the replies.

I am using this thread to do the transformation, I did bind it to a tag which may be my problem. I will look into binding it to a property and see if this resolves the issue. Any other tips would be appreciated as well.

> [@\[Feedback\] NEW Perspective Table](https://forum.inductiveautomation.com/t/feedback-new-perspective-table/21199/48):
>
> For anyone wondering how they might be able to add custom row styles (and configuration) based upon a rows value derived from a dataset. You’ll need to create a transform on the bound dataset using a script like this example: output\_json = [] style\_orange = {"backgroundColor": "#F7901D"} style\_green = {"backgroundColor": "#00AA00"} for row in range(value.getRowCount()): row\_object = {} row\_value = {} row\_style = {} for col in r…

---

_[View the full topic](https://forum.inductiveautomation.com/t/transforming-large-datasets-eating-too-much-memory/77715)._