Hi,
Markus Hoenicka wrote the following on 17.06.2009 16:03:
>
> I'd say the driver is pretty much dormant. The latest oracle-specific
> changes have been committed approx. one year ago. According to what I
> read on the list, the driver is not in a shape that would allow us to
> call Oracle fully supported.
Either way I need a working Oracle driver for libdbi. The single
driver-api mainly directed into ndoutils code ("liboci"), is already
there and working with Oracle 11g but ndoutils will get obsolet in
Nagios and the focus will step further using the libdbi (and not MySQL
or Postgre).
>
> Is that something like precompiled statements? This would be
> interesting to have, but I don't see sufficient developer resources to
> implement this anytime soon.
Yep, that's what i meant. Before working with Oracle I didn't meant it
to be a performance thing but I've seen the differences with 1 query and
different values resulting in approx 100k queries.
You are preparing the statement with placeholders and it will be
calculated and cached. After that, you may run a loop and binding your
values to that placeholders defined. The RDBM will notice that and merge
the given vlues into the cached query.
I think it's pretty much the same als Perl's DBD - prepare the query and
then execute it. Using Oracle the OCI provides several functions for
that but I didn't see any in the libdbi interface (which I am pretty
sure I need to modify a bit later on if I get the driver to work again).
Right now I'm a bit busy but next week I will catch on the driver and
see what we can get out of it.
Kind regards,
Michael
>
> regards,
> Markus
>
>
--
DI (FH) Michael Friedrich
michael.friedr...@univie.ac.at
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Libdbi-drivers-devel mailing list
Libdbi-drivers-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
