Wow, what a question. Are you re-engineering a database system?
Quote:
|
- When and how it's best time to dump the tables to a file?
|
On slightly-less than gigabyte boundaries. Actually, 256 kB blocks also work very well.
Quote:
|
- Who should dump the metadata produced to file? Different thread?
|
If it's in a different thread, what's the point? You can't just free the memory if the other thread still has a lock on it.
Quote:
|
What policy should I use to load the data
|
I don't think that's answerable unless one really knows your existing software architecture.
