LinkBack URL
About LinkBacks
When power query is calculating data is that powered by RAM or the CPU ?
Thanks
When power query is calculating data is that powered by RAM or the CPU ?
Thanks
Computing is not a matter of CPU or RAM. That's like asking whether a truck carries a load using the motor or the trailer. You need both. The calculations are performed by the CPU. RAM is used to hold data. The more interesting question is which one is the limiting factor for any particular application. For example, Google Chrome uses a lot of RAM but not much CPU. What Power Query uses depends entirely on what you are doing with it, but is it very likely CPU-intensive.
We can give you better information if you can explain what you are trying to get at with your question.
Yes, you are correct.
I have two processes I do commonly. I wonder if I can increase the speed at which these tasks complete.
Here are some specs for my desktop: 32 GB DDR4 ram and a i9 10900KF processor.
The first process relates to power query.
I use power query to combine and analyze either, large csv files or many json files.
The second process relates to a VBA I had written for me that scrapes json's from an API.
The cookie needed to scrape the API is only good for one hour, and the amount of data can exceed that.
I am going to upgrade from 32 GB ram to 96 GB. Any other ideas how to speed up either process? (without re-writing the VBA code)
You should monitor system performance using Task Manager, or something more sophisticated, to see where the limit is. You are using some pretty heavy-duty hardware there.
I'm a little unclear on your description. Are you saying that you have a task that takes longer than an hour?
Yes, potentially longer than an hour, to download all the json files from the API.
I've attached two pictures
The pic with 2% CPU usage is when I'm downloading the json files from the API via a VBA in excel.
The pic with 53% CPU usage is when I'm using power query to combine jsons and export to the data to an excel worksheet.
Doesn't look like I'm bottlenecking with the RAM or CPU.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks