Cache a CSV View into Memory
17 November, 2014
Hi,
Is it possible to cache is CSV View which is sorted in MS SQL Server into the Yellowfin Columnar Memory DB?
The reason I want to do this is to improve data access performance since the data is stored in memory and not on disk.
Thanks,
Nick
Is it possible to cache is CSV View which is sorted in MS SQL Server into the Yellowfin Columnar Memory DB?
The reason I want to do this is to improve data access performance since the data is stored in memory and not on disk.
Thanks,
Nick
Hi Nick,
You cannot cache a view in YF that is based off a CSV file.
Unfortunately, if you want to store a CSV file, you have to dump the file somewhere other than the columnar DB.
Regards,
David
You cannot cache a view in YF that is based off a CSV file.
Unfortunately, if you want to store a CSV file, you have to dump the file somewhere other than the columnar DB.
Regards,
David