Re: [GENERAL] function taking a long time. any options o speed it up.

2006-07-19 Thread Rhys Stewart
well i started by creating a table with the data i needed, instead of working on the big tablethat helped a whole lot. thanks. On 7/18/06, Michael Fuhr <[EMAIL PROTECTED]> wrote: On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote: > i created a function and it takes a long time to

Re: [GENERAL] function taking a long time. any options o speed it up.

2006-07-18 Thread Michael Fuhr
On Tue, Jul 18, 2006 at 08:11:40AM -0500, Rhys Stewart wrote: > i created a function and it takes a long time to run. I was testing it > as a wrote it and to the first drop table it takes just short of a > second. however when the rest of the code is added on, it takes > upwards of 5 minutes. Not t

[GENERAL] function taking a long time. any options o speed it up.

2006-07-18 Thread Rhys Stewart
Hi all, i created a function and it takes a long time to run. I was testing it as a wrote it and to the first drop table it takes just short of a second. however when the rest of the code is added on, it takes upwards of 5 minutes. Not the most appropriate thing. Are there any tips out there for