Yes, now that I think of it, there is one of these "crazy" joins that's probably coming into play that joins each of my 7000 rows with 65 rows in a different table, so that table must have about 450,000 rows. Any good optimization approaches for these type of one to "very many" relationships? recursive fetch? I can see this table getting into the many millions of rows real fast.
On Tuesday, December 16, 2008, at 11:09PM, "Chuck Hill" <[email protected]> wrote: >Either some crazy joins with other tables or something you are not >aware of is going on. 7K rows is tiny. > >Chuck > > >On Dec 16, 2008, at 9:07 PM, Jeff Schmitz wrote: > >> hmm, I'm not doing an insert at all, just a read. Kind of thought >> there must be something else too though (with my limited experience) >> but figured indexing would be a good thing to do regardless before >> digging into debugging the real culprit here. >> >> Jeff >> >> On Dec 16, 2008, at 11:01 PM, Mike Schrag wrote: >> >>>> More than a minute to insert to a 7000 row table? >>>> Do other operations on the same DB take an appropriate amount of >>>> time? If not I would start looking at DNS or other connectivity >>>> issues. I can't fathom a FB DB sucking at that level. >>> this was my first thought, too ... something else is going on >>> here. I suspect if sql debug was turned on, you'd see tons of >>> faulting going on that you didn't realize and that the insert >>> itself is not actually the slow thing. >>> >>> ms >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/jeffandmonica%40mac.com >>> >>> This email sent to [email protected] >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> http://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net >> >> This email sent to [email protected] >> > >-- >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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
