http://dev.helma.org/bugs/show_bug.cgi?id=662 Summary: getDBConnection() to oracle db in 1.6.3 slower than in
1.5
Product: Helma
Version: 1.6.3
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: P5
Component: Database Layer
AssignedTo:
helma-dev@...
ReportedBy:
marius.lessiak@...
When retrieving a connection to an oracle DB via a call to getDBConnection
helma 1.6.3 is slower than helma 1.5. Attached is a minimal testcase app that
needs to be run with an enabled oracle database. I verified the slowdown with
an oracle 10g db using the ojdbc14.zip driver set (see
http://www.google.at/search?hl=de&q=ojdbc14.jar&btnG=Google-Suche&meta=&aq=0&oq=ojdbc)
and with an older oracle 8 db.
With helma 1.5 the first call to getDBConnection() takes about 400ms (on my
setup, the time varies with the specific db setup), all subsequent calls take
less than 0ms. With helma 1.6.3 the first call takes the same 400ms (as im
helma 1.5) whereas all subsequent calls take around 100ms. Maybe helma 1.6.3
does not reuse some stuff that helma 1.5 does?
By the way: the slowdown is not reproducible with a mysql db.
--
Configure bugmail:
http://dev.helma.org/bugs/userprefs.cgi?tab=email------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Helma-dev mailing list
Helma-dev@...
http://helma.org/mailman/listinfo/helma-dev
