Changes between Version 47 and Version 48 of ConfigOptions

Timestamp:

Dec 27, 2018, 1:54:52 AM (5 years ago)

Author:

Markus Neteler

Comment:

+OGR_SQLITE_CACHE, OGR_SQLITE_SYNCHRONOUS

ConfigOptions

@@ -420 +420 @@
 SQLite driver specific. Set to "YES" to list all tables (not just the tables listed in the geometry_columns table)
 
+=== OGR_SQLITE_CACHE ===
+
+SQLite driver specific. Added in GDAL/OGR 1.9.0. Can be set to e.g. to `OGR_SQLITE_CACHE=1024` to define the internal Page Cache size [value being measured in MB]; if your hardware has enough available RAM, defining a Cache size as big as 512MB (or even 1024MB) may sometimes help a lot in order to get better performance.
+
+=== OGR_SQLITE_SYNCHRONOUS ===
+
+SQLite driver specific. Setting `OGR_SQLITE_SYNCHRONOUS=OFF` might also increase performance when creating SQLite databases (although at the expense of integrity in case of interruption/crash).
+
 === OGR_SQLITE_LIST_VIRTUAL_OGR ===
 
-Sqlite driver specific. Added in GDAL/OGR 1.10. Set to "YES" to list VirtualOGR layers. Defaults to "NO" as there might be some security implications if a user is provided with a file and doesn't know that there are virtual OGR tables in it.
+SQLite driver specific. Added in GDAL/OGR 1.10. Set to "YES" to list VirtualOGR layers. Defaults to "NO" as there might be some security implications if a user is provided with a file and doesn't know that there are virtual OGR tables in it.
 
 === OGR_EDIGEO_FONT_SIZE_FACTOR ===