when you add a category, does it automatically rebuild the category table by itself?
Nov 1, 2004, 5:53 AM
Veteran / Moderator (18436 posts)
Nov 1, 2004, 5:53 AM
Post #2 of 10
Views: 3206
Its nice an simple: When you add a subcategory, the entry is added into lsql_Category ..
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!

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!
Nov 1, 2004, 5:59 AM
Novice (19 posts)
Nov 1, 2004, 5:59 AM
Post #3 of 10
Views: 3203
I guess what I'm asking here is:
is there any directory structure/ bread crumb rebuilding going on?
If I have 10 000 categories or 10 categories, does the time it take to either update / add a category/subcategory differ? Does the system have to go and update some categories or breadcrumbs because of a change to one of the categories somewhere in the heirachy?
is there any directory structure/ bread crumb rebuilding going on?
If I have 10 000 categories or 10 categories, does the time it take to either update / add a category/subcategory differ? Does the system have to go and update some categories or breadcrumbs because of a change to one of the categories somewhere in the heirachy?
Nov 1, 2004, 6:05 AM
Veteran / Moderator (18436 posts)
Nov 1, 2004, 6:05 AM
Post #4 of 10
Views: 3205
Ah, I see. Well, there is Full_Name, which is held in the Category table. When a category is modified, a global update of all its subcategories, etc are changed too. If you delete a category, then again, all the subcategories are modified (or deleted, in this case).
Hope that helps :)
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!
Hope that helps :)
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!
Nov 1, 2004, 6:28 AM
Veteran / Moderator (18436 posts)
Nov 1, 2004, 6:28 AM
Post #6 of 10
Views: 3210
You would only really notice a slow down, if you have a hell of a lot of categories below it (i.e over 10,000 sub-cats). Anything less, and there isn't that huge amount of speed differences.
Sorry, don't have any :(
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!
Quote:
Any metrics on it?Sorry, don't have any :(
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!
Nov 1, 2004, 10:44 AM
Administrator (9387 posts)
Nov 1, 2004, 10:44 AM
Post #7 of 10
Views: 3215
Hi,
Build All will rebuild the entire directory tree. Build Changed will only rebuild what has changed since the last build. If you add a category, it means rebuilding that category, and all it's parents.
Speed of building depends on many factors such as server speed, directory size, avg number of links per category, etc.
Cheers,
Alex
--
Gossamer Threads Inc.
Build All will rebuild the entire directory tree. Build Changed will only rebuild what has changed since the last build. If you add a category, it means rebuilding that category, and all it's parents.
Speed of building depends on many factors such as server speed, directory size, avg number of links per category, etc.
Cheers,
Alex
--
Gossamer Threads Inc.
Nov 1, 2004, 2:34 PM
Enthusiast (928 posts)
Nov 1, 2004, 2:34 PM
Post #8 of 10
Views: 3206
Hi.
Is it planned to add something like:
"Build New"
Which only builds the stuff that has never been built before particularly with respect to "New" links added. Actually with a pretty large directory (large number of links), the static part could become really killing while rebuilding after adding few links to a directory with 100,000 links say. Otherwise, with a large number of links, the static part would have to be given up coz of resources involved during a build operation.
Thanks
HyTC
Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Is it planned to add something like:
"Build New"
Which only builds the stuff that has never been built before particularly with respect to "New" links added. Actually with a pretty large directory (large number of links), the static part could become really killing while rebuilding after adding few links to a directory with 100,000 links say. Otherwise, with a large number of links, the static part would have to be given up coz of resources involved during a build operation.
Thanks
HyTC
Thanks
HyTC
==================================
Mail Me If Contacting Privately Is That Necessary.
==================================
Nov 9, 2004, 10:49 AM
Novice (19 posts)
Nov 9, 2004, 10:49 AM
Post #10 of 10
Views: 3179
Hi,
How does the admin section handle having like 10 000 or 20 000 categories/sub-categories?
Any expierenc with this? On average, what do most people have in terms of # of cats?
If I wanted to import the entire Dmoz, how many cat's are we talking here? (that should be the maximum anyone would need!)
How does the admin section handle having like 10 000 or 20 000 categories/sub-categories?
Any expierenc with this? On average, what do most people have in terms of # of cats?
If I wanted to import the entire Dmoz, how many cat's are we talking here? (that should be the maximum anyone would need!)