aboutsummaryrefslogtreecommitdiffstats
path: root/railties
diff options
context:
space:
mode:
authorJeremy Kemper <jeremy@bitsweat.net>2006-11-13 07:36:52 +0000
committerJeremy Kemper <jeremy@bitsweat.net>2006-11-13 07:36:52 +0000
commita303a168ac88d3c5e7a7e71a0c84ea3c2a44f972 (patch)
treecdd9f4d353f452328b7bfd3f4a03ba761682107d /railties
parent45fd631e5e8ff45ed5fcec67905088b30fd2b297 (diff)
downloadrails-a303a168ac88d3c5e7a7e71a0c84ea3c2a44f972.tar.gz
rails-a303a168ac88d3c5e7a7e71a0c84ea3c2a44f972.tar.bz2
rails-a303a168ac88d3c5e7a7e71a0c84ea3c2a44f972.zip
Oracle: to increase performance, prefetch 100 rows and enable similar cursor sharing. Both are configurable in database.yml. Closes #6607.
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5509 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
Diffstat (limited to 'railties')
-rw-r--r--railties/configs/databases/oracle.yml11
1 files changed, 10 insertions, 1 deletions
diff --git a/railties/configs/databases/oracle.yml b/railties/configs/databases/oracle.yml
index 3c3c8f8b13..c86cbdbaba 100644
--- a/railties/configs/databases/oracle.yml
+++ b/railties/configs/databases/oracle.yml
@@ -6,7 +6,16 @@
# Specify your database using any valid connection syntax, such as a
# tnsnames.ora service name, or a sql connect url string of the form:
#
-# //host:[port][/service name]
+# //host:[port][/service name]
+#
+# By default prefetch_rows (OCI_ATTR_PREFETCH_ROWS) is set to 100. And
+# until true bind variables are supported, cursor_sharing is set by default
+# to 'similar'. Both can be changed in the configation below; the defaults
+# are equivalent to specifying:
+#
+# prefetch_rows: 100
+# cursor_sharing: similar
+#
development:
adapter: oracle