file system vs sql database
Hello, I figure there's no other place to ask this thing around (general development forums? doesn't seem to be here), so I guess since I'm doing this in c++ this is the best place to ask..
I will have millions of record, and each have relations to around 6ish other records. Each of these records would be around 200 bytes or less.. and they'll only ever be accessed by an index number (which is a long).
The question is, would it be better to store these under sql, or would it be better to just store these under the file system, with the file names as their indexes? If I use SQL, all I'll be doing is just "select entry where index = X" or something like that..
And then there's the caching thing.. does sql (e.g mysql) provide caching for the most retrieved files, or anything like that?
Thanks in advance.. its hard to find info on this (for a beginner like me that is :)