• Topic
  • Discussion
  • UdaWikiWeb.GlossaryEntrySQLROWSETSIZE(Last) -- Owiki? , 2016-08-19 15:00:08 Edit owiki 2016-08-19 15:00:08

    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 #


    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


    Referenced by...