Home
SQL Image Viewer online help Prev Page Prev Page
Introduction
About SQL Image Viewer
Version history
Contact us
User Guide
System requirements
Editor command selection
Exporting large number of images
Folders and files
Reference Guide
Main menu
Connect to Database
Connecting to Firebird databases
Connecting to MySQL databases
Connecting to Oracle databases
Connecting to SQLite databases
Connecting to SQL Server databases
Connecting using ODBC
Connecting to a DB2 database
Connecting to a PostgreSQL database
Options
General options
Editor options
Thumbnail options
Image view
Check for updates
About
The work area
SQL editor
Table browser
Results
Other binary data
Image viewer
Hex viewer
Export items wizard
Exporting Microsoft Access OLE data
Image options
File naming convention
Datetime format specifiers
Command line interface
Parameters, logs and exit codes
Advanced options
CROP option
Troubleshooting
Expired trial
Invalid licenses
Unidentified images or binary data

General options


options - general2


Database connection timeout
This is the maximum time (in seconds) in which SQL Image Viewer will wait while attempting to connect to the selected database.

This option applies only when connecting to Microsoft SQL Server databases.

Virtual memory limit
SQL Image Viewer will consume a lot of memory when fetching result sets containing large images. Setting this option allows SQL Image Viewer to stop fetching records from the database when SQL Image Viewer's virtual memory utilization exceeds this limit.

The default value is 128 MB below the installed physical memory. This means that if your workstation has 512 MB of RAM installed, SQL Image Viewer will stop fetching data when its virtual memory utilization reaches 384 MB.

Note that this setting affects only queries ran from the SQL editor. Queries ran from the Export Images Wizard are not affected by this limit. See this guide for further details.

Sample rows to retrieve
For MySQL 5, SQL Server and SQLite databases, this value is the number of rows that SQL Image Viewer will retrieve when you double click on the table name in the table browser.

Temporary folder for files
This is the folder that SQL Image Viewer uses to store temporary files, when you choose to open them from within SQL Image Viewer.