Note: You must be registered in order to post a reply. To register, click here. Registration is FREE! Before posting, make sure you have read this topic!
T O P I C R E V I E W
blackinwhite
Posted - 28 October 2006 : 10:29:13 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.
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.<
2 L A T E S T R E P L I E S (Newest First)
Astralis
Posted - 05 November 2006 : 14:23:01 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.
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.<
blackinwhite
Posted - 05 November 2006 : 14:18:56 any comments?<