it did.. thanks.. generally a weeks process turned out to be less than a
day..
On Thursday 25 November 2004 15:06, Christopher Kings-Lynne wrote:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in
(select
mobile_num from LOADED_MOBILE_NUMBERS)
Change to:
Dear JM ,
Ive been using postgres for 3 years and now we are having problems
with its
PostgrSQL version please
--
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk
---(end of
PG Version 7.3.4
On Thursday 25 November 2004 14:12, Vishal Kashyap @ [SaiHertz] wrote:
Dear JM ,
Ive been using postgres for 3 years and now we are having
problems with its
PostgrSQL version please
---(end of broadcast)---
TIP 9:
SQL:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
mobile_num from LOADED_MOBILE_NUMBERS)
Could you try using UPDATE ... FROM (SELECT ) AS .. style syntax?
About 20 minutes ago, I changed a 8 minute update to an most instant by
doing that.
regards
Iain
On Thu, 25 Nov 2004 14:00:32 +0800, JM [EMAIL PROTECTED] wrote:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in
(select
mobile_num from LOADED_MOBILE_NUMBERS)
does loaded_mobile_numbers have a primary key or index on mobile_num?
same for subscriptiontable?
have
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where mobile_num in (select
mobile_num from LOADED_MOBILE_NUMBERS)
Change to:
update SUBSCRIPTIONTABLE set ACTIVEFLAG='Y' where exists (select 1 from
LOADED_MOBILE_NUMBERS lmn where
lmn.mobile_num=SUBSCRIPTIONTABLE.mobile_num);
That should run a