[DB-SIG] Oracle Module for win32??

Max Slimmer Max.Slimmer@RightWorks.com
Mon, 20 Sep 1999 23:15:57 -0700


This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01BF03F8.C71B0DF8
Content-Type: text/plain;
	charset="iso-8859-1"

Keep in mind that acquiring a connection to Oracle takes several seconds,
you should run your test with a persistent connection. The differences in
timing you are seeing are most surely because of this, and not ODBC.
max

-----Original Message-----
From: Risney, Marc S [mailto:msrisney@ingr.com]
Sent: Monday, September 20, 1999 11:05 PM
To: 'Anthony Baxter'; 'db-sig@python.org'
Subject: RE: [DB-SIG] Oracle Module for win32?? 


Yes, both mxODBC and M. HAmmond's ODBC from the win32 do work
however Performance, seems a bit off,
on a joined query, where a 100K recordset table is keyed, the query takes
roughly 30 - 40 secs to retrieve the resulting recordset..and roughly the
same time in a VBA from using the supplied Oracle ODBC driver


with an Oracle OLE object in a VB Form the same query results almost
instantaneoulsy

it seems that the overhead of the ODBC is slowing my app down, since I would
like to develop a client that is "cross platform" using Tkinter< I am trying
to work with this object

any help would be appreciated
 

-----Original Message-----
From: Anthony Baxter [mailto:anthony@interlink.com.au]
Sent: Monday, September 20, 1999 11:02 PM
To: Risney, Marc S
Subject: Re: [DB-SIG] Oracle Module for win32?? 


>>> "Risney, Marc S" wrote
> Hey Pythoneers,
> 
> I am attempting to work with Digitalk Creations DCOracle , but cannot get
it
> to compile,
> does anyone please have a compiled .pyd or a decent Oracle module
> please help..

Does ODBC not work for you?


_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
http://www.python.org/mailman/listinfo/db-sig

------_=_NextPart_001_01BF03F8.C71B0DF8
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: [DB-SIG] Oracle Module for win32?? </TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Keep in mind that acquiring a connection to Oracle =
takes several seconds, you should run your test with a persistent =
connection. The differences in timing you are seeing are most surely =
because of this, and not ODBC.</FONT></P>

<P><FONT SIZE=3D2>max</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Risney, Marc S [<A =
HREF=3D"mailto:msrisney@ingr.com">mailto:msrisney@ingr.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, September 20, 1999 11:05 PM</FONT>
<BR><FONT SIZE=3D2>To: 'Anthony Baxter'; 'db-sig@python.org'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [DB-SIG] Oracle Module for win32?? =
</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Yes, both mxODBC and M. HAmmond's ODBC from the win32 =
do work</FONT>
<BR><FONT SIZE=3D2>however Performance, seems a bit off,</FONT>
<BR><FONT SIZE=3D2>on a joined query, where a 100K recordset table is =
keyed, the query takes</FONT>
<BR><FONT SIZE=3D2>roughly 30 - 40 secs to retrieve the resulting =
recordset..and roughly the</FONT>
<BR><FONT SIZE=3D2>same time in a VBA from using the supplied Oracle =
ODBC driver</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>with an Oracle OLE object in a VB Form the same query =
results almost</FONT>
<BR><FONT SIZE=3D2>instantaneoulsy</FONT>
</P>

<P><FONT SIZE=3D2>it seems that the overhead of the ODBC is slowing my =
app down, since I would</FONT>
<BR><FONT SIZE=3D2>like to develop a client that is &quot;cross =
platform&quot; using Tkinter&lt; I am trying</FONT>
<BR><FONT SIZE=3D2>to work with this object</FONT>
</P>

<P><FONT SIZE=3D2>any help would be appreciated</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Anthony Baxter [<A =
HREF=3D"mailto:anthony@interlink.com.au">mailto:anthony@interlink.com.au=
</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Monday, September 20, 1999 11:02 PM</FONT>
<BR><FONT SIZE=3D2>To: Risney, Marc S</FONT>
<BR><FONT SIZE=3D2>Subject: Re: [DB-SIG] Oracle Module for win32?? =
</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>&gt;&gt;&gt; &quot;Risney, Marc S&quot; wrote</FONT>
<BR><FONT SIZE=3D2>&gt; Hey Pythoneers,</FONT>
<BR><FONT SIZE=3D2>&gt; </FONT>
<BR><FONT SIZE=3D2>&gt; I am attempting to work with Digitalk Creations =
DCOracle , but cannot get</FONT>
<BR><FONT SIZE=3D2>it</FONT>
<BR><FONT SIZE=3D2>&gt; to compile,</FONT>
<BR><FONT SIZE=3D2>&gt; does anyone please have a compiled .pyd or a =
decent Oracle module</FONT>
<BR><FONT SIZE=3D2>&gt; please help..</FONT>
</P>

<P><FONT SIZE=3D2>Does ODBC not work for you?</FONT>
</P>
<BR>

<P><FONT =
SIZE=3D2>_______________________________________________</FONT>
<BR><FONT SIZE=3D2>DB-SIG maillist&nbsp; -&nbsp; =
DB-SIG@python.org</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://www.python.org/mailman/listinfo/db-sig" =
TARGET=3D"_blank">http://www.python.org/mailman/listinfo/db-sig</A></FON=
T>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01BF03F8.C71B0DF8--