<docbook><section><title>GlossaryEntrySQLROWSETSIZE</title><para> </para><bridgehead class="http://www.w3.org/1999/xhtml:h2">Glossary of Technical Terms</bridgehead>
<para><ulink url="GlossaryEntriesA">A</ulink> <ulink url="GlossaryEntriesB">B</ulink> <ulink url="GlossaryEntriesC">C</ulink> <ulink url="GlossaryEntriesD">D</ulink> <ulink url="GlossaryEntriesE">E</ulink> <ulink url="GlossaryEntriesF">F</ulink> <ulink url="GlossaryEntriesG">G</ulink> <ulink url="GlossaryEntriesH">H</ulink> <ulink url="GlossaryEntriesI">I</ulink> <ulink url="GlossaryEntriesJ">J</ulink> <ulink url="GlossaryEntriesK">K</ulink> <ulink url="GlossaryEntriesL">L</ulink> <ulink url="GlossaryEntriesM">M</ulink> <ulink url="GlossaryEntriesN">N</ulink> <ulink url="GlossaryEntriesO">O</ulink> <ulink url="GlossaryEntriesP">P</ulink> <ulink url="GlossaryEntriesQ">Q</ulink> <ulink url="GlossaryEntriesR">R</ulink> <ulink url="GlossaryEntriesS">S</ulink> <ulink url="GlossaryEntriesT">T</ulink> <ulink url="GlossaryEntriesU">U</ulink> <ulink url="GlossaryEntriesV">V</ulink> <ulink url="GlossaryEntriesW">W</ulink> <ulink url="GlossaryEntriesX">X</ulink> <ulink url="GlossaryEntriesY">Y</ulink> <ulink url="GlossaryEntriesZ">Z</ulink> <ulink url="GlossaryEntriesSymbols">#</ulink></para><bridgehead class="http://www.w3.org/1999/xhtml:h2">SQL_ROWSET_SIZE</bridgehead>
<para>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.</para><para>Note: This parameter should not be confused with the SQL_ROWSET_SIZE setting used for scrollable cursors.</para><para>Example: SQL_ROWSET_SIZE</para><para>100 </para></section></docbook>