Displaying 1 result from an estimated 1 matches for "oci_test".
Did you mean:
mci_test
2005 Sep 07
0
using Oracle bind vars in Rails
...s supported in other dbs, but Oracle''s OCI
driver supports late binding with dramatically improved performance.
I did a quick test to confirm that I could expect the same performance
improvement through the Ruby OCI8 driver, and in a simple test it looks
to be a 5x improvement.
$ ruby oci_test.rb
user system total real
dynamic sql: 8.000000 0.870000 8.870000 (429.277514)
bind vars: 12.530000 0.930000 13.460000 ( 82.228332)
Not likely to be noticed in a small scale app that''s just got a handful
of queries or DML per request. But our site provides...