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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly