Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Re: [pugdog] Reverse operations for category deletion?

Quote Reply
Re: [pugdog] Reverse operations for category deletion? In reply to
True, it may be simpler for smaller categories... but doing it on larger categories is hell, especially when it times out. I've noticed it a lot when doing DMOZ dumps, and then having to delete large categories because they are not needed. If, at any point it times out, the whole deletion process will not run again, and you have to run a CGI script to go through the lsql_Links, lsql_Category and lsql_CatLinks tables, to get rid of the links Frown

The only reason I mention this, is because this problem has just happened to me. The categories were only 1,000 or so links... but the database is 2.7million ... it just gave up, and now I'm having to write a script to get rid of them all :(

Wouldn't it be possible to use the current way for smaller categories, and the reverse of it for anything over say 2,000 links? Maybe something for GT to look into?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread Reverse operations for category deletion? Andy 1399 Aug 31, 2003, 6:12 AM
Thread Re: [Andy] Reverse operations for category deletion?
pugdog 1350 Aug 31, 2003, 7:34 AM
Post Re: [pugdog] Reverse operations for category deletion?
Andy 1354 Aug 31, 2003, 7:56 AM