Heavy data load

[tex628]

Hello, I'm looking for some advice! 

I'm currently running a report with an increadibly large .txt file as a source. The file is on 2.5GB and therefore the loadtime from the query is really long, making it quite difficult to work. 

In the query I'm placing filters on date that should mean that i load less than half of the table but it still insists of loading all of the 2,5GB... 

Anyone have any advice on how to lessen the load?

Br,

Johannes

[Stachu]

I'd try disabling background preview download, it may improve the experience

Is the load long when you apply the steps, or when you transform the query?
If it's the transformation then you can create a smaller version of the file, e.g. 100MB to do the initial setup and later just switch connection to the bigger file

[tex628]

Working within the query is no problems at all, but any change in the big file triggers the load and you're stuck with a 15 min query load. I'm gonna see if i can put a filter in the software that produces the sourcefile, might be possible to reduce it there. I'm not confident enough to go into the txt file manually and reduce it!

Thanks! 

/ J