[thelist] CF - MAXROWS

Jeff jeff at members.evolt.org
Sat Jul 22 14:11:06 CDT 2000


palyne,

:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: Palyne Gaenir <palyne at sciencehorizon.com>
:
: Is it FASTER (processing-wise) if you specify a BLOCKFACTOR
: in query tags that are expected to return more than 1 record?  So
: it only makes one trip to the DB for the rows?  And would there be
: any performance-harm to spec'ing a high# BF just in case?
:~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

since queries that have a higher blockfactor set require more available
memory from the server then i would have to say that it should be used very
sparingly.

good luck,

.jeff

name://jeff.howden
game://web.development
http://www.evolt.org/
mailto:jeff at members.evolt.org





More information about the thelist mailing list