Forum

This content is now out of date.

Visit Our Community

Cache a CSV View into Memory

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
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