[egenix-support] Re: [egenix-users] Calling Stored Procedures

[Fabio Rizzo Matos]

On 3/9/07, eGenix Support <support at egenix.com> wrote:
>
> Am 09.03.2007, 13:22 Uhr, schrieb Fabio Rizzo Matos <fabiorizzo at gmail.com
> >:
>
> > unixODBC-2.2.11-1.RHEL4.1.
> > Are you connecting to the database via a
> > network or on the same machine?
> > By Network. The database is in another machine.
> > Which Oracle ODBC driver are you using?
> > Oracle Client 10.2.0.1.0
>
> You might want to upgrade the Oracle driver- I think there is a more
> recent one. But that shouldn't make that much off a difference. Have you
> run any comparative tests using iSQL? How long are the queries taking and
> how long do they take if you run them directly on the Oracle machine? If
> there is a difference would it be possible to test the setup on the db as
> quite often the network is the source of delays.



I'm not run  any test using iSQL, how i run it? The query running in Oracle
Machine is fast, but when run by the zope machine, the time is more longer.


Charlie
>
> --
> Charlie Clark
> eGenix.com
>
> Professional Python Services directly from the Source
> >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
> >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
> >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> Try mxODBC.Zope.DA for Windows, Mac OS, Linux, Solaris, FreeBSD for free!
>



-- 
Fabio Rizzo
ThreePointsWeb
fabiorizzo at threepointsweb.com
----
-------------- next part --------------
An HTML attachment was scrubbed...
URL: /mailman-archives/egenix-users/attachments/20070309/d953aa7d/attachment.htm