This content has been marked as final. Show 4 replies
Make sure you have all the appropriate indexes on your database, and in general have tuned it for the style of access by the batch processor.
Otherwise, yep, it'll be slow.
I should rephrase the questions...
Can someone provide an example of a batch .Net config to connect to Oracle?
Are there any parameters to tune from the OPA side of the house for databases (specifically Oracle)? (For instance, is --blocksize relevant with Oracle?)
The .NET version of the Batch Processor does not currently support database connections. As identified in the documentation - see http://docs.oracle.com/html/E36316_01/Content/Batch%20Processor/Dbase_Input_for_Batch_Processor.htm - database connectivity is supported for the Java version only.
Edited by: Ben O'Keeffe on 24-Sep-2012 16:56
Edited by: Ben O'Keeffe on 24-Sep-2012 16:58
Ah. That solves my .Net connectivity problem :-)
Now I have to figure out why a single oracle table with only 5 input columns for the conditions and 1 output column for the conclusion is taking so long to process...
Since I have now examined every variable available to me from OPA, I can ask the DBAs to look on their side.