Re: Further: Some help with Optimization
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