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

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.