View Single Post
06-07-2012, 05:06 PM
#6
Village Genius is offline Village Genius
Village Genius's Avatar
Status: Geek
Join date: Apr 2006
Location: Denver, CO
Expertise: Software
Software: Chrome, Notepad++
 
Posts: 6,894
iTrader: 18 / 100%
 

Village Genius will become famous soon enough

  Old

Right. Those are bad for this because they require too much maintenance. You'll have to have one when posts are added, deleted, or moved. Furthermore if the trigger should for some reason fail you'll have to recompile all your data to make it valid again. Preforming counts on the spot requires no maintenance and has less ways to fail.

Reply With Quote
Thanked by:
Dan (06-13-2012)