Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Though I don't see anyone ever talk about it, the blocksizes from any network logical volume (Novell, NT) can be adjusted to the needs. Thinking native VFP tables only (for now), this would imply that the logical volume for the dbf should have the smallest blocksize possible. Why ? because we, the users, communicate at the record level, and they are generally assumed to be smaller than the smallest possible blocksize. Thus, when we fetch a record of 100 bytes, we'd better deal with a block that's near to that length. For a Novell OS the minimum (I think) is 4KB, and for NT is (I think) 512 bytes.
The user make communicate at the "record" level, but FoxPro will frequently communicate at its own "block" level.
FoxPro will do "large block reads" (in the order of 64KB); that's how it gets some of its performance, by in fact, "reading ahead". So tinkering with the OS at the block/sector may be at odds with what FoxPro typically does.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement