Advantages and Dis-advantages of SqlComputeCode.
Good afternoon, I have working prototypes of each of these approaches. I do not have an expansive cache background.
I have a couple of projects where I am ingesting files from disk.
The name of the file contains a lot of the information I will need to reference the file in the future.
What are the advantages and dis-advantages of these two approaches:
Store the whole filename and use SqlComputeCode to populate properties in a class?
Parse the data out of the filename on ingestion into properties in a class?
For each approach what are the implications to indexing?
Thank you.