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
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!
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!