The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
You know the tagging stuff, http://en.wikipedia.org/wiki/Tag_(metadata). It's very popular after all web 2.0 talks.
Apart form Forums/Categories, I want to use tagging for my forum.
AS for the code part, http://www.dblog.it/public/post/tag-cloud-in-asp-505.asp function works like a charm.
But I want to have your ideas about database scheme.
In terms of performance, is it a good idea to have a database scheme like this?;
FORUM_TAGS
_______________
TOPIC_ID
TAG
Have a nice weekend,
is.<
Apart form Forums/Categories, I want to use tagging for my forum.
AS for the code part, http://www.dblog.it/public/post/tag-cloud-in-asp-505.asp function works like a charm.
But I want to have your ideas about database scheme.
In terms of performance, is it a good idea to have a database scheme like this?;
FORUM_TAGS
_______________
TOPIC_ID
TAG
Have a nice weekend,
is.<
Posted
any comments?<
Posted
With your version, I think you're going to run into some major performance issues down the road.
I've developed the system linked before for my CMS and haven't had a problem in terms of performance because the MSSQL Server index is built well. It would be nice if this could be added for Snitz or at least a retro-tagging feature that could be run monthly. I can no longer use search and I have mssql server. Tagging could help that.
http://tumanov.com/projects/tags_asp/
Even after developing this, I recommend that you build a static html file on a daily or weekly basis with your tag cloud and call that page instead and you could even go with your version because if you're only going to run it once a day it really won't matter how inefficient it is.<
I've developed the system linked before for my CMS and haven't had a problem in terms of performance because the MSSQL Server index is built well. It would be nice if this could be added for Snitz or at least a retro-tagging feature that could be run monthly. I can no longer use search and I have mssql server. Tagging could help that.
http://tumanov.com/projects/tags_asp/
Even after developing this, I recommend that you build a static html file on a daily or weekly basis with your tag cloud and call that page instead and you could even go with your version because if you're only going to run it once a day it really won't matter how inefficient it is.<