Re: which database to use with PE and big datasets
You mean running out of memory while loading the data from the CSV in a load script?
If that is the case - the loading of the data into QlikView in-memory through a SQL-database will not make a difference. Using a SQL-database as a source does not help on memory. I
f you on the other hand use Direct Dicovery for your fact table then using a SQL-database will help. But it comes with some trade-offs and limitations. So I am pretty sure that doing the following two things first will be most useful for you:
1) Look at how the data you bring in can be made less memory consuming.