> Ok, it is because it is a Thursday! I had a function that was doing > this and one of the parameters how the tables were linked (PK filed). > Turns out I had written it using Macro expansion (&). I have just > changed that to a named variable () and it has sped up something > wonderful! > > Mike, that's an interesting way of doing it. I shall take note and > possibly implement this <g> >
I invented that technique because a process that was bringing in 100K records a day into over a million records was doing something like your original code. It was taking hours to run in the morning before the work day began. The 100K records were each being checked by seeks in the million. After making that change it took something like 20 minutes. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
