[python-win32] python-win32 Digest, Vol 87, Issue 3

[Mauricio Martinez Garcia]

On response: 

row--mins--LOG_PYTHON: register info
192--1.62111605008--LOG_PYTHON: 526862501806|6130314|6130314|01|01|s|s|
CELIT710|CELIT710|AC|0|57.22|
0                                                                                                   
193--1.6306677858--LOG_PYTHON: 523330779616|5038757|5038757|01|01|s|s|
CPLUS1315|CPLUS1315|AC|0|1790.77|
0                                                                                                
194--1.64019101858--LOG_PYTHON: 522464589571|5039835|5039835|01|01|s|s|
CPLUS015|CPLUS015|AC|0|240.64|
0                                                                                                  
195--1.65014798244--LOG_PYTHON: 528115941967|5035308|5035308|01|01|s|s|
CCT1316|CCT1316|AC|0|382.43|
1.08                                                                                                 
196--1.66029798587--LOG_PYTHON: 522226159880|5033797|5033797|01|01|a|a|
CCT1316|CCT1316|AC|0|282.15|0
197--1.67140610218--LOG_PYTHON: 527351660404|5032529|5032529|01|01|s|s|
CCT1316|CCT1316|AC|0|392.35|0
198--1.68326413234--LOG_PYTHON: 527351660042|7204513|7204513|01|01|s|s|
CPLUS015|CPLUS015|AC|0|364|0 
199--1.69420450131--LOG_PYTHON: 529932672067|5029001|5029001|01|01|s|s|
CPLUS015|CPLUS015|AC|0|349.46|
0                                                                                                  
200--1.70307114919--LOG_PYTHON: 529932672069|5029006|5029006|01|01|s|s|
CPLUS015|CPLUS015|AC|0|364|0 
201--1.71299698353--LOG_PYTHON: 524641211699|6738198|6738198|01|01|s|s|
CPLUS015|CPLUS015|AC|0|291.89|
0                                                                                                  
202--1.72252208392--LOG_PYTHON: 522226163037|6391680|6391680|01|01|s|s|
CPLUS015|CPLUS015|AC|0|364|0 
203--1.73303683599--LOG_PYTHON: 528117371540|7844922|7844922|01|01|a|a|
CCT116|CCT116|AC|0|374.3|0   
204--1.742791152--LOG_PYTHON: 528115945727|5003318|5003318|01|01|s|s|
CPLUS015|CPLUS015|AC|0|353.08|0
205---2.1497408549e-06--LOG_PYTHON: 528113804731|5000770|5000770|05|05|
a|a|CPLUS015|CPLUS015|AC|0|-139.041|0|0|0|0|0|0|1|000001  



On Fri, 2010-06-04 at 12:00 +0200, python-win32-request at python.org
wrote: 

> Message: 4
> Date: Thu, 3 Jun 2010 15:16:50 -0400
> From: Trent Nelson <trent at snakebite.org>
> To: <python-win32 at python.org>
> Subject: Re: [python-win32] How can improvement time of response of
> 	Python cx_Oracle
> Message-ID: <4C07FFA2.4000701 at snakebite.org>
> Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
> 
> On 6/3/2010 1:50 PM, Mauricio Martinez Garcia wrote:
> > The time for an comparation of 2 DBs are many.
> > Python: 1 - 2 mins by rows.
> > Java 0.02 - 0.10 secs by rows.
> 
> > I need improvement the time of response of 1 - 2 minutes to 0.02 -
> > 0.10 secs. How can this?.
> 
> Out of interest, have you ruled out that the Python overhead isn't 
> incurred by just establishing the connection?  Oracle interop can be 
> funny sometimes -- underlying configuration oddities can hang initial 
> connection attempts by a couple of minutes.
> 
> How long does it take to establish a connection and run a dummy query?
> 
> 	Trent.
> 
> 
> ------------------------------
> 
> _______________________________________________
> python-win32 mailing list
> python-win32 at python.org
> http://mail.python.org/mailman/listinfo/python-win32
> 
> 
> End of python-win32 Digest, Vol 87, Issue 3
> *******************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20100617/96a662fd/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 835 bytes
Desc: This is a digitally signed message part
URL: <http://mail.python.org/pipermail/python-win32/attachments/20100617/96a662fd/attachment-0001.pgp>