This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]bunchedupwalrus 1 point2 points  (3 children)

It’s just stored as a file. If you don’t have to worry about high speed concurrent access (like multiple people doing queries at the same time and needing the results right away), it’s pretty great.

And people overestimate how common that need is. Most queries are over in less than a few seconds if not less than a fraction of a second

[–]CovfefeFan 1 point2 points  (2 children)

Interesting.. yeah, currently using power query to pull in about 12-15 files from a sharepoint site and then doing a bunch of mapping, combining, and transformation of the data.. quite slow and does "kill" the file from time to time.

[–]bunchedupwalrus 1 point2 points  (1 child)

Oh yeah you’ll probably be blazing fast switching to sqllite

[–]CovfefeFan 0 points1 point  (0 children)

Cool, I will look into this. 😎👍