Glossary of Technical Terms

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

SQL_ROWSET_SIZE

The SQL_ROWSET_SIZE parameter appears in the [Client] section of your virtuoso.ini file. This parameter sets the number of rows prefetched at execute and on subsequent fetch requests. A high SQL_ROWSET_SIZE value will enable you to speed up long selects. However, this may be disadvantageous, if you fetch only the first few rows from a cursor with a large result set.

Note: This parameter should not be confused with the SQL_ROWSET_SIZE setting used for scrollable cursors.

Example: SQL_ROWSET_SIZE

100