Re: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS?

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

On Fri, Oct 5, 2012 at 11:13 AM, Ivan Voras <ivoras@xxxxxxxxxxx> wrote:

> On the other hand, if the temp table can be completely ditched for a

> session variable or two, then yeah, that would be much better since
> you'd avoid the overhead of creating the table completely.

Yes, this is what I was aiming at, based on the OP mentioning he only
has a limited amount of data to manage in this way.

Yup, I'm going to see how this goes using session variables. I think it is exactly what I need. Thanks!

--

Moshe Jacobson
Nead Werx, Inc. | Senior Systems Engineer

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com