> Something else to consider... databases love doing bulk operations. It > might be useful to load prospective data into a temporary table, and > then do as many operations as you can locally (ie: within the database) > on that table, hopefully eleminating as many candidate rows as possible > along the way.
I wish this would work... it was definitely something I considered early on in the project. Even thinking of explaining why it won't work is giving me a headache... But I sure wish it would. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
