Problem with the 'RESIDENT' statement is that you are re-reading the whole table, and if it is millions of records, you might want to avoid. There is one solution in the blog I have mentioned, and another one using the 'FROM_FIELD' statement. Problem is that I can't find any example on the web.
How do we use it?! I want to see its benefits. Thanks in advance,
Too bad that the 'STORE' statement does not accept any where clause. There are example to split qvd by year, but they don't show us the code to produce those qvd. And it does not make sense that I re-execute my SQL query year by year...
Well in that case you do the "Load FiedValue"-trick as described in the blog post you linked to.
I have never used the FROM_FIELD feature, so I can't help you with that.
If you want to STORE part (not all records) of a QV Table you need to create a new QV Table which just those records,
for example like this
1 As dummy // this is to make Facts2010 different from Facts
Drop Field dummy;
Store Facts2010 Into Facts2010.qvd;
Drop Table Facts2010;
Did you get a solution to your problem using from_field ? I am also stuck in a similar situation where FieldX exists in Table A and FieldX also exists in Table B and both are associated via FieldX. However, I need to find min and max of FieldX only in Table A. Since the size of Table A is very big, it takes a lot of time to scan through all content. Therefore, please share your thoughts if you got a resolution to this problem.