sqlite - The best way to store big number of files with adding quick search -

in windows 8/rt app use sqlite database (sqlite-net) witch store in isolated storage. in database have lot of data, including files(images, pdf's , other) links. links web server. when got link, want download file , store locally.

question is: best way store big number of files (100+)?
1 important think: i need organize find desired file.

i have 3 ideas:

1. create database files (i can't modify existing)
2. create folder in , store here directly.
3. create list of files , store in is.

which better/faster? or have great solution?

100 files isn't such big number can store 100k files (or folders) in single (ntfs) directory.

if receive files webserver question whether source makes sure there no duplicate filenames. if can't assured, i'd recommend having database table mapping original filename , metadata hash (sha256 or similar) , store file filename corresponding hash.

then, when using file, can pass pass user using original filename using storagefile api.

going beyond 100k files, create subfolder structure first 2 letters of hash.

either way, storing file metadata in database , files in directory has been useful approach in past.