Re: SQL Tunning

From: <bblfree_at_my-deja.com>
Date: Thu, 25 Jan 2001 21:30:12 GMT
Message-ID: <94q5sm$6jj$1@nnrp1.deja.com>

Hi,
sorry for my bad english....
I want to know if the following procedure has low performance when the table is large.
Procedure xxx

   select count(*)
   into cant
   from table1
   where table1.col1 = value1

if cant=0

insert into table1....

end
The application that we're testing has procedures of that kind for all operations. They don't manage exceptions because they verify the condition before; but I think it's worst... Is that OK?

Thanks.

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 25 2001 - 15:30:12 CST