It's a funny thing I've noticed but a surefire way to speed up any of my SQL procedures is to stick print statements in giving the time at various points so you can figure out where the bottlenecks are. It seems to make the processor think "Yikes, someone's watching!" :)
no subject
Date: July 7th, 2006 01:23 pm (UTC)From: