I have played around Node-Red for getting excel file from the disk and displaying its values in the HTTP response object. The source Excel file contained only 10 to 15 records. I have an excel file which contains sensor values of different types (like one column contains heart rate and other contains activity etc.) in 30 different columns and each column contains more than 100,000 values. So, I used this new file which is sized about 35 Mb to display the specific column values of it and when I press deploy, the Node-Red goes on deploying for a while. When I check my ram memory, it is getting filled in task manager of windows which in turn crashes Node-Red.
What I understand and assume is Node-Red is loading all values of that specific column into RAM memory and because of it RAM memory gets filled and node red is forced to close which results in the crash of Node-Red. What am I trying to achieve actually is that I want to select two different columns of this excel file and each of these columns contains sensor values from different sensors. I, then, want to repeatedly compare this each pair from every row of excel values and display result if the value of one column is greater/smaller than the other (some threshold I will set).
In short, loop through all pair of values of two columns of excel, compare each pair and show result based on the comparison. I will be very relieved if someone could help me out. I am using it for learning purposes and want to work on a real project if I get success on it.