Re: Updates, deletes and inserts are very slow. What can I do make them bearable?

On Thu, Oct 21, 2010 at 1:37 PM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

>
>
> On 10/21/2010 10:27 AM, Scott Marlowe wrote:
> > On Thu, Oct 21, 2010 at 9:33 AM, Brian Hirt <bhirt(at)me(dot)com> wrote:
> >>>
> >>> There are only two tables in the query.
> >>>
> >>
> >> Tim,
> >>
> >> No, your query is written incorrectly. I don't understand why you come
> on to this list all hostile and confrontational. Regardless, people still
> try to help you and then you still ignore the advice of people that are
> giving you the solutions to your problems.
> >
> > Maybe he's used to paid commercial support where people are often
> > quite rude and hostile to the support staff to try and "motivate" them
> > or something? I've seen it before for sure.
> >
> > Again, OP, what does EXPLAIN say about this query?
> >
>
> Maybe I should re-read, but I didn't feel any confrontation.
> Frustration for sure. OP has clearly tried pretty hard, on some tricky
> bits too, but I'm betting all for naught if (as seems likely) it's just
> mistaken sql. "update from" is NOT straight forward.
>
>
i had the same feeling than brian and scott, but i am one of the
"questioners" not the "answerers" on the list, so i didnt said anything...
but the "i-am-touching-many-parameters-and-doesnt-work" and then complain is
not one of the best strategies...
the SQL sentence is far more complicated than it pretended to be...

--
Roberto Scattini
___ _
))_) __ )L __
((__)(('(( ((_)