cx oracle - Python - Usefulness of threads with cx_oracle -

-

based on following context:

  • open connection oracle database
  • execute 1 select query
  • close connection

is useful use threads handle database connection , query execution? library cx_oracle manage enough trust execution?

for example, in case of database being on loaded (by other connections), keep connection open undefinetly? other scenario case: query has conditions, limit number of rows. if number of rows increase drastically, query take more time execute. useful thread query execution, following post.

i have seen cx_oracle can combine threads multiple insertions, or more complex software. in simpler case, wonder...

thanks lot.


Comments

Post a Comment

Popular posts from this blog

Capture and play voice with Asterisk ARI -

-
there channel ari demo in wich can control channel state: ring, answer, play silence, play tone or audio-file ( https://github.com/asterisk/ari-examples/tree/master/channel-state , https://wiki.asterisk.org/wiki/display/ast/ari+and+channels%3a+manipulating+channel+state ) possible receive chunks (parts, buffers, etc.) of call voice (which created remote subscriber) or write chunks of voice, example array of bytes (not file) in audio format (alaw, ulow etc). you can use asterisk eagi interface voice data. other option use record or mixmonitor app record channel(channel have put stasis allow dialplan control ari) "write chunks of voice" can done application playback also can create own application using c/c++, compile asterisk , result want. no, can't redirect voice directly using ari.
Read more

c++ - Can not find the "fiostream.h" file -

-
i'm learning c++ now. here question: #include <fiostream.h> no matter used: #include <fiostream> #include "fiostream" #include "fiostream.h" i can not find "fiostream.h" file anywhere. where can find "fiostream.h" file? does "iostream.h" include "fiostream.h"'s functions? what's difference between "fiostream.h" , "iostream.h"? thank you~~ what's difference between "fiostream.h" , "iostream.h"? the difference “f”. neither header exists. iostream does, fiostream doesn’t (but fstream does).
Read more

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -

-
i spotted odd behavior in hsql, seems when using database transactions database contraints not checked during sql inserts during sql commits , when transaction rollbacked not checked @ all. i have spring integration test: @runwith(springjunit4classrunner.class) @transactionconfiguration(defaultrollback=true, transactionmanager="transactionmanager") @transactional public class integrationtest { with test creates new entity instance , calls hibernate's persist on it. it works fine, when change defaultrollback false fails: caught exception while allowing testexecutionlistener [org.springframework.test.context.transaction.transactionaltestexecutionlistener@517a2b0] process 'after' execution test: method [public void myintegrationtest.test()], instance [myintegrationtest@546e61d5], exception [null] org.springframework.dao.dataintegrityviolationexception: not execute statement; sql [n/a]; constraint [null]; nested exception org.hibernate.exception.const...
Read more