Snitz™ Forums 2000
https://forum.snitz.com/forumTopic/Posts/63129?pagenum=1
05 November 2025, 00:07
Topic
blackinwhite
Tag Clouds Mod - ideas
28 October 2006, 10:29
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.<
Replies ...
blackinwhite
05 November 2006, 14:18
any comments?<
Astralis
05 November 2006, 14:23
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.<