Matt,
> After playing with various indexes and what not I simply am unable to
> make this procedure perform any better. Perhaps someone on the list can
> spot the bottleneck and reveal why this procedure isn't performing that
> well or ways to make it better.
Well, my first thought is that this is a pretty complicated procedure for
something you want to peform well. Is all this logic really necessary?
How does it get done for MySQL?
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco