On Wed, 2 Jul 2003, Matthew Hixson wrote:
> Thanks for all your help, Scott. A friend of mine whipped out this
> script which runs a lot faster than trying to use the original query I
> posted.
> -M@
>
> begin;
> create temporary table cart_temp as select distinct a.cart_id,
> a.cart_cookie from v_carts a, v_cart_contents b where a.cart_id =
> b.cart_id;
> delete from v_carts;
> insert into v_carts (cart_id, cart_cookie) select cart_id, cart_cookie
> from cart_temp order by cart_id;
> drop table cart_temp;
> commit;
> vacuum analyze verbose v_carts;
> reindex table v_carts;
Good ole batch processing. :-) Glad you got it working.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
