X-Git-Url: https://pintos-os.org/cgi-bin/gitweb.cgi?a=blobdiff_plain;f=doc%2Ffiles.texi;h=ded40e7b9222aea362f9ee5b32f01ab4ec6cd24c;hb=89a1e7f479414c1a2345e33210d69e91e61b33ac;hp=df01567eb956efd64df16ca7feff2e4fba3e93e9;hpb=da333d7456a56655ebf4ce0e16e6cf468ab1c1af;p=pspp-builds.git diff --git a/doc/files.texi b/doc/files.texi index df01567e..ded40e7b 100644 --- a/doc/files.texi +++ b/doc/files.texi @@ -265,7 +265,8 @@ GET DATA /TYPE=PSQL /CONNECT=@{connection info@} /SQL=@{query@} [/ASSUMEDVARWIDTH=n] - [/UNENCRYPTED]. + [/UNENCRYPTED] + [/BSIZE=n]. @end display @cindex postgres @@ -303,6 +304,17 @@ Whether or not the connection is encrypted depends upon the underlying psql library and the capabilities of the database server. +The BSIZE subcommand serves only to optimise the speed of data transfer. +It specifies an upper limit on +number of cases to fetch from the database at once. +The default value is 4096. +If your SQL statement fetches a large number of cases but only a small number of +variables, then the data transfer may be faster if you increase this value. +Conversely, if the number of variables is large, or if the machine on which +PSPP is running has only a +small amount of memory, then a smaller value will be better. + + The following syntax is an example: @example GET DATA /TYPE=PSQL