S
Simon L. Prinsloo
Guest
Multiple extents means you have multiple file handles. I do not know how the OS / FS support reliable simultaneous access for multiple processes to a single file, but I can imagine that there will be some sort of contention, at least some of the time. Distributing the access over more files may have the type of effect that Richard talk about. On the other hand, most of the new data generated in a business application originates from the transactional functions, which tends to be generated sequentially, updated rarely, if ever. That data is often time sensitive and will loose relevance to most queries within the span of one to 12 months. So the bulk of the access will in any case be near the high water mark...
Continue reading...
Continue reading...