• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Further: Some help with Optimization
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Further: Some help with Optimization


  • Subject: Re: Further: Some help with Optimization
  • From: Owen McKerrow <email@hidden>
  • Date: Fri, 10 Feb 2006 10:40:44 +1100


On 10/02/2006, at 10:18 AM, Chuck Hill wrote:

And the bit about 100 x 9 = 1836? :-P

Well 100 x 8 = 1800 which wouldn't get the extra 36 records so it does 9 "requests" to get those extra ones, thats all that I had meant. As you will see below it turned out to be 1888 not 1836 anyways :)


There is 1836 records, so I would have thought 9 times ( to get all the objects in batches of 100 ).

How long is the SQL taking to run? Nothing is jumping out at me. 10 seconds is way too long though...


Chuck

Here's the SQL with the batch size set to 2000 :

Get Authors :2006-02-09 23:11:17 Etc/GMT

[2006-02-10 10:11:16 EST] <WorkerThread0> === Begin Internal Transaction
[2006-02-10 10:11:16 EST] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression: "SELECT DISTINCT t0.academicGeneral, t0.accessLevel, t0.brandNewRecord, t0.countryID, t0.email, t0.fileName, t0.filePath, t0.hasFile, t0.institution, t0._rowid, t0.serialNumber, t0.staffNumber, t0.title, t0.tobeShown, t0.type, t0.updatedNightly, t0.URL FROM PERSON t0, PERSON_NAME T1 WHERE t0.type = ? AND t0._rowid = T1.personID ORDER BY T1.lastName ASC" withBindings: 1:4(type)>
[2006-02-10 10:11:18 EST] <WorkerThread0> 1885 row(s) processed
[2006-02-10 10:11:18 EST] <WorkerThread0> === Commit Internal Transaction


Get names via value for key :2006-02-09 23:11:18 Etc/GMT

[2006-02-10 10:11:18 EST] <WorkerThread0> evaluateExpression: <com.webobjects.jdbcadaptor.OpenBasePlugIn$OpenBaseExpression: "SELECT t0.active, t0.creationDate, t0.firstName, t0.initial, t0.lastName, t0.personID, t0._rowid FROM PERSON_NAME t0, PERSON T1 WHERE ((t0.personID = ? OR t0.personID = ? OR .....

...... repeated 1885 odd times, I cut them out so the email is shorter.......

..... OR t0.personID = ?) AND T1.type = ?) AND t0.personID = T1._rowid" withBindings: 1:2946(personID), 2:3204(personID), 3:3061 (personID),.......

... again1885 personID values, I cut them out so the email isn't to long........

1884:2748(personID), 1885:3178(personID), 1886:4(type)>
[2006-02-10 10:11:31 EST] <WorkerThread0> 1888 row(s) processed
[2006-02-10 10:11:31 EST] <WorkerThread0> === Commit Internal Transaction


End :2006-02-09 23:11:31 Etc/GMT



So cutting that down even further we have :

Get Authors :2006-02-09 23:11:17 Etc/GMT

[2006-02-10 10:11:16 EST] <WorkerThread0> === Begin Internal Transaction
[2006-02-10 10:11:18 EST] <WorkerThread0> 1885 row(s) processed


Get names via value for key :2006-02-09 23:11:18 Etc/GMT

[2006-02-10 10:11:18 EST] <WorkerThread0> evaluateExpression: .....
[2006-02-10 10:11:31 EST] <WorkerThread0> 1888 row(s) processed
[2006-02-10 10:11:31 EST] <WorkerThread0> === Commit Internal Transaction


End :2006-02-09 23:11:31 Etc/GMT




_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Further: Some help with Optimization
      • From: Chuck Hill <email@hidden>
References: 
 >Some help with Optimization (From: Owen McKerrow <email@hidden>)
 >Further: Some help with Optimization (From: Owen McKerrow <email@hidden>)

  • Prev by Date: Further: Some help with Optimization
  • Next by Date: Re: Some help with Optimization
  • Previous by thread: Further: Some help with Optimization
  • Next by thread: Re: Further: Some help with Optimization
  • Index(es):
    • Date
    • Thread