You can translate the question and the replies:

Nested Array

Hi, I was wondering what would be the best way to create ARRAY inside an ARRAY, especially when you have huge data source(8M records)? I achived it using derived views but because of the data, when I create the 2nd ARRAY with ARRAY( from the derived view) inside it, it runs for a very long time, which offsets its functionality. So, can you please suggest a better way? Thank you in advance. Thanks & Regards, Anoop Gundabattina.
user
26-07-2018 17:49:27 -0400
code

1 Answer

Hi, The best way to have an array inside an array is how I expect you did it with derived views, creating a view at each level of the nest statement. If you’re having performance issues with it, I would suggest making sure cache is set up for the view. Details about configuring cache for the server can be found [here](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_cache/configuring_the_cache), and details regarding the cache at the view level are [here](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/advanced_characteristics/using_the_cache/using_the_cache). I hope this helps!
Denodo Team
30-07-2018 12:49:24 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here