Gossamer Forum: Products: Gossamer Links: Discussions: GT::SQL::table()->delete() Question...

Gossamer Threads

Home : Products : Gossamer Links : Discussions :

GT::SQL::table()->delete() Question...

Jul 2, 2004, 1:16 AM

Andy

Veteran / Moderator (18441 posts)

Jul 2, 2004, 1:16 AM

Post #1 of 2

Shortcut

GT::SQL::table()->delete() Question...

Just a quick question. Currently I am using the following to delete a list of links that have LinkOwner => ALLPOSTERS.

Code:
    my $sth = $DB->table('Links')->select( { LinkOwner => "ALLPOSTERS" } ) || die $GT::SQL::error; 
    while (my $hit = $sth->fetchrow_hashref) { 
      push(@delete_ids,$hit->{ID}); 
    } 

    foreach (@delete_ids) {  
     $DB->table('Links')->delete( { ID => $_ } ); 
     print "Deleting lsql_Links: $_ \n"; 
    }

This seems *very* slow (even with 20,000 records). I've tried a couple of other approaches, of which none seem to work :(

Any ideas?

$DB->table('Links')->delete( { LinkOwner => "ALLPOSTERS" } );

TIA

Andy (mod)
andy@ultranerds.co.uk

Jul 2, 2004, 2:08 AM

Andy

Veteran / Moderator (18441 posts)

Jul 2, 2004, 2:08 AM

Post #2 of 2

Shortcut

Re: [Andy] GT::SQL::table()->delete() Question... In reply to

Managed to get around it by using;

Code:
my $poster_root_cat = $DB->table('Category')->select( ['ID'],{ AllPOSTERS_ID => 0 } )->fetchrow; 
$DB->table('Category')->delete( { ID => $poster_root_cat } );

Cheers

Andy (mod)
andy@ultranerds.co.uk

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676