Re: optimization/indexing
Re: optimization/indexing
- Subject: Re: optimization/indexing
- From: Jeff Schmitz <email@hidden>
- Date: Fri, 19 Dec 2008 08:26:19 -0600
Whoops, I think I misread the suggestion.
No, there wasn't an index for WinAnalysis.comboTeamID. And creating
one makes a HUGE HUGE HUGE (enough emphasis??) difference. from
minutes to less than a second to load the page. So it was the
'indexes' after all.
Again, many thanks, I should have a good nights sleep tonight :-)
Jeff
On Dec 19, 2008, at 8:05 AM, Jeff Schmitz wrote:
OK, I tried to do this, and in the process hit a dialogue that said
I had to change my transaction settings to be serializable,
pessimistic, read write. Are these setting just for the FrontBase
Manager app, or global (i.e. also for my webobjects app?).
Anyway, after saying ok, change my transactions settings, I then got
an error that "Only explicit indeces can be dropped". So, I was
unable to drop my index and re-build it.
btw, why does the Mail app say 'indeces' is misspelled? Guess we're
supposed to stick to the more pedestrian 'indexes'. And they call
Mac users elitist ;-)
Jeff
On Dec 18, 2008, at 10:45 PM, Chuck Hill wrote:
On Dec 18, 2008, at 8:40 PM, Jeff Schmitz wrote:
Does WinAnalysis.comboTeamID have an index? I'd guess that it
does and that the index is corrupt. Or that is one VERY large
table and there is no index. If you can get FrontBase to use an
IN instead of ORs that will also make it faster, but you have
some kind of hunka burning serious SQL problem happening there.
It does have an ID, but it's an "owns destination" relationship.
And it is pretty large.
And ID or an index? Look at that table in FrontBaseManager, check
the indexes. If there is one, drop it and recreate it. If there is
not one, add it. Did that help?
Chuck
--
Chuck Hill Senior Consultant / VP Development
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:
This email sent to email@hidden
_______________________________________________
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