Hi, > Fragmentation at file system (OS) level will have much more impact on large > files, caching (at OS level) will be less effective too, read-ahead capabilities will be less effective too and finally IO load will increaseinevitably.
Could you please provide links to back this up? Or provide a test case that shows multiple small files are significantly faster than one large file (given the same file operations)? > It is easy to measure the degradation of the performance of a database as the > data volume is significantly increased. Do you think the database will be faster if you split it into multiple files? I don't think so. But if you want, H2 supports the "split file system". You can easily find out. This also has the advantage that all files are about the same size (less files). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
