Our BI resource has brought to our attention that when creating an app within Qlicksense he must load a heavy amount of data from our Salesforce environment. At times this data load can take anywhere from 5 to 20 minutes. Each time he makes changes to the code he must perform another load. He's spending a lot of time waiting for the data load. Currently our server has 16GB of RAM. Would upgrading the RAM have a significant improvement on his data load times? Thanks in advance for any suggestions.
Very unlikely. He could however use QVD-files to have a staging layer for the data and that can siginificantly speed up the reload process - up to 20 times the speed when it comes to relation databases and probably more with Salesforce.
Buffer is a cache mechanism so you can specify the update frequency. It will not use any timestamp field - it is not an alternative to incremental load. It makes you less dependent on reading the source and speeds up the development significantly.