Not having to reload all data each reload

[#1]

When I make changes to my load script while developing I dont' want to have to reload all 10million lines of data each time. What ist he best way to keep the data loaded but not have it reload each time i make a script change in dev?

Thanks,

[#2]

Hello Anthony, the best way I have found is using limited load(script debug setting) while I am developing, probably you would want to load less than 10,000 registers. On the other hand, it would be painful to reload every time directly from the source, so usually I load all data into qvds straight from the source and read the qvds in the actual application. Once your data model is stable you can perform better extraction.

Hope this helps you.

Regards

[#3 · Accepted solution]

I used to do that except you dont' get to chose what data to load. Instead I just added a simple where statement to load most recent years.

Thanks,