Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Most strange corruption ever
Message
De
28/08/2003 22:15:09
Gerry Schmitz
GHS Automation Inc.
Calgary, Alberta, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00692378
Message ID:
00824452
Vues:
22
>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
Fil
Voir

Click here to load this message in the networking platform