[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Are Batch Sequences Possible ?

Subject: Re: Are Batch Sequences Possible ?
From: Chuck Hill <email@hidden>
Date: Mon, 29 Oct 2007 21:52:24 -0700
Delivered-to: email@hidden
Delivered-to: email@hidden

Short answer: yes.

Mike recently added something to the FrontBase plugin(?) in Wonder to do this. I imagine that the same thing could be done for Oracle. There are primary key generators in GVCEOFExtensions that also do this (get a batch from the DB and allocate them locally).

The method we used was in EODatabaseContext's delegate interface, databaseContextNewPrimaryKey(EODatabaseContext dbCtxt, Object object, EOEntity entity)

I'm not sure what Mike did for his.

Chuck


On Oct 29, 2007, at 8:49 PM, Owen McKerrow wrote:

Hi All,
Im currently developing an app against a Oracle databas, which uses sequence for generating its Primary Keys.

Is there a way to get WO to request a batch of sequences instead of doing it one at a time ( which is what it appears to be doing when you output the SQL ). For example I am doing 1 save to the database that is inserting 142 rows into 1 table, 142 into a second and 711 into a third. Each of the 142 row table inserts takes 2 seconds to return all of the sequence while the 711 inserts take's 8 seconds to get the sequences. Thats 12 seconds used before it even starts the INSERT statements, which take another 2, 2 and 8 respectively. Meaning the total save time is 24 seconds ( with SQL debugging turned on, its a little quicker with it turned off ).

Please someone tell me Im doing something dumb, or that there is a better way.
Heres a cut down version of the SQL output......
14:22:44,154 DEBUG [WorkerThread2] (RQFBOWSelection:286 setUpPublicationsList) - Save Start. 14:22:44,415 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Begin Internal Transaction 14:22:44,416 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "SELECT t0.pub, t0.ABSTRACT FROM PUB_ABSTRACT t0 WHERE t0.pub = ?" withBindings: 1:8657(pubID)>
Repeated 141 for 2 secconds
14:22:46,521 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Begin Internal Transaction 14:22:46,522 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "SELECT RQF_GRP_PSN_PUB_SEQ.NEXTVAL FROM DUAL">
Repated 142 for  2 seconds
14:22:48,045 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Begin Internal Transaction 14:22:48,046 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "SELECT AUDIT_LOG_SEQ.NEXTVAL FROM DUAL">
Repeated 711 for  8 seconds
14:22:56,928 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Begin Internal Transaction 14:22:56,929 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "SELECT RQF_PUB_SEQ.NEXTVAL FROM DUAL"> Repeated 141 for . 2 seconds 14:22:58,782 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Begin Internal Transaction 14:22:58,783 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "INSERT INTO RQF_PUB(NOTES, OUTLET_ANGLICISED_TITLE, LANGUAGE_OF_TITLE, LOCKED, TYPE_OTHER_DESCRIPTION, METRICS_IDENTIFIER, OUTPUT_IDENTIFIER, RQF_PUB, ENGLISH_TITLE, PUB, IS_REPRINT, SENSITIVITY_EXPLAINATION, AVALIABLE_YEAR, ANGLICISED_TITLE, IS_COMMERCIAL_SENSITIVE, TYPE_CODE, IS_CULTURALSENSITIVE, OUTLET_RANKING_IDENTIFIER, AVAILABILITY_FORM, OUTLET_ENGLISH_TITLE, AVAIL_STATUS_CODE, NON_REPOSITORY_JUSTIFICATION, YEAR_VARIANCE_JUSTIFICATION, RQF_YEAR) VALUES (NULL, NULL, NULL, ?, NULL, NULL, NULL, ?, NULL, ?, ?, NULL, NULL, NULL, ?, NULL, ?, NULL, NULL, NULL, ?, NULL, NULL, ?)" withBindings: 1:0(locked), 2:2266(rqfPUBID), 3:8430 (pubID), 4:0(reprint), 5:0(commercialSensative), 6:0 (culturalSensative), 7:"R"(availabilityStatusCode), 8:21(rqfYearID)>
Repeatd 142  for  2 seconds
14:22:59,717 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "INSERT INTO RQF_GRP_PSN_PUB(PERSON, RQF_PUB, GRP, RQF_GRP_PSN_PUB, TYPE) VALUES (?, ?, ?, ?, ?)" withBindings: 1:12545(personID), 2:2342(rqfPubID), 3:373(groupID), 4:2542 (rqfGrpPersonPubID), 5:1(type)>
Repeatd 141 for  2 seconds
14:23:00,368 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - evaluateExpression: <com.webobjects.jdbcadaptor.OraclePlugIn $OracleExpression: "INSERT INTO AUDIT_LOG(CLASSES_NAME, ATTRIBUTES_NAME, person, old_value, RIS_SESSION_ID, message, new_value, audit_log, ip_address, when, OBJECTS_PK) VALUES (?, ?, ?, NULL, ?, ?, ?, ?, ?, ?, ?)" withBindings: 1:"Publication"(classesName), 2:"rqfDetails"(attributesName), 3:3462 (person_fk1), 4:"hSSnp5XU8DNKnd0MFSCRHM"(risSessionID), 5:"RELATIONSHIP_ADDED"(message), 6:"RQFPub:({values = {notes = <com.webobjects.foundation.NSKeyValueCoding$Null>; typeCode = <com.webobjects.foundation.NSKeyValueCoding$Null>; languageOfTitle = <com.webobjects.foundation.NSKeyValueCoding$Null>; locked = 0; metricsIdentifier = <com.webobjects.foundation.NSKeyValueCoding $Null>; outputIdentifier = <com.webobjects.foundation.NSKeyValueCoding$Null>; titleInEnglish = <com.webobjects.foundation.NSKeyValueCoding$Null>; rqfYear = "<RQFYear f2486b _EOIntegralKeyGlobalID[RQFYear (java.lang.Long)21] >"; publication = "<Publication 5d9805 _EOIntegralKeyGlobalID [Publication (java.lang.Long)10988]>"; reprint = 0; rqfGroupPersonBOWPubs = ("<RQFGroupPersonPubBOW e66ae7 <EOTemporaryGlobalID: 0 0 -126 -126 72 73 0 0 -39 3 -101 0 0 0 1 21 -18 -19 -49 65 -71 -42 -47 95>>"); sensitivityExplaination = <com.webobjects.foundation.NSKeyValueCoding$Null>; avaliabilityYear = <com.webobjects.foundation.NSKeyValueCoding$Null>; anglicisedTitle = <com.webobjects.foundation.NSKeyValueCoding $Null>; commercialSensative = 0; rqfGroupPersonOldBOWPubs = (); rqfGroupPersonNRPubs = (); anglicisedOutletsTitle = <com.webobjects.foundation.NSKeyValueCoding$Null>; outletRankingIdentifier = <com.webobjects.foundation.NSKeyValueCoding$Null>; culturalSensative = 0; otherTypeDescription = <com.webobjects.foundation.NSKeyValueCoding$Null>; avalaibleFrom = <com.webobjects.foundation.NSKeyValueCoding$Null>; outletsTitleInEnglish = <com.webobjects.foundation.NSKeyValueCoding $Null>; availabilityStatusCode = "R"; nonRepositoryJustification = <com.webobjects.foundation.NSKeyValueCoding$Null>; yearVariationJustification = <com.webobjects.foundation.NSKeyValueCoding$Null>; }; this = "<RQFPub 10347e <EOTemporaryGlobalID: 0 0 -126 -126 72 73 0 0 -39 3 -102 0 0 0 1 21 -18 -19 -49 65 -71 -42 -47 95>>"; }) {null}"(newValue), 7:1324858(audit_log_pk), 8:"/ 130.130.72.73"(ipAddress), 9:2007-10-30 14:22:44(when), 10:10988 (objectsPK)>
Repeated 717 for 8 seconds
14:23:08,538 DEBUG [WorkerThread2] (Log.NSLogDebug:1546 appendln) - === Commit Internal Transaction 14:23:08,575 DEBUG [WorkerThread2] (RQFBOWSelection:289 setUpPublicationsList) - Save End.
Owen McKerrow
WebMaster, emlab
Ph : +61 02 4221 5517
http://emlab.uow.edu.au
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 'The test of a first-rate intelligence is the ability to hold two opposed ideas in the mind at the same time and still be able to function.' -F.Scott Fitzgerald,

_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/chill% 40global-village.net
This email sent to email@hidden

--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/products/practical_webobjects

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/email@hidden

This email sent to email@hidden

Follow-Ups:
- Re: Are Batch Sequences Possible ?
  - From: Owen McKerrow <email@hidden>
- Re: Are Batch Sequences Possible ?
  - From: Mike Schrag <email@hidden>
- Re: Are Batch Sequences Possible ?
  - From: Mike Schrag <email@hidden>

References:
	>Are Batch Sequences Possible ? (From: Owen McKerrow <email@hidden>)

Prev by Date: Re: Database choices
Next by Date: Re: Database choices
Previous by thread: Are Batch Sequences Possible ?
Next by thread: Re: Are Batch Sequences Possible ?
Index(es):
- Date
- Thread

Home