From 5aab49586b238001f6b1ba085658ee1f14b37542 Mon Sep 17 00:00:00 2001
From: icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Tue, 11 Mar 2008 10:13:01 +0000
Subject: Marcus Povey <marcus@dushka.co.uk> * Removed count based on this
 conversation:
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

[10:05:38] … basically, if you add an item, you need to create a tag entry in the metastrings table (as discussed yesterday)
[10:05:56] … if you then delete the item, that leaves a tag
[10:06:07] … if you want to delete the tag when nothing references it
[10:06:11] … it needs a counter
[10:06:29] … which means for every add and delete query you need to check for and sometimes update this counter
[10:06:36] … making three queries for every one
[10:06:47] … but if you don't do that the meta strings table grows over time
[10:06:54] … making it space inefficient
[10:07:03] … so, which do you do?
[10:10:31] … ?
[10:10:43] … i'd be tempted to not delete
[10:10:58] … because the multiple queries will be a pain for everyone all the time
[10:11:05] … and storage costs are cheap
[10:11:32] Ben Werdmuller: I would be very tempted to do the same
[10:11:35] … so let's do that :)
[10:11:36] Marcus Povey: maybe we could write an admin script to clean up or something
[10:11:45] Ben Werdmuller: exactly, we could clean up on a cron if people really want
[10:11:59] … but for now, let's just go with the growing tag cloud

git-svn-id: https://code.elgg.org/elgg/trunk@149 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 1 -
 1 file changed, 1 deletion(-)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 18e7b6eb0..0170b5aef 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -231,7 +231,6 @@ CREATE TABLE `prefix_metadata` (
 CREATE TABLE `prefix_metastrings` (
 	`id` int(11) NOT NULL auto_increment,
 	`value` text NOT NULL,
-	`count` int(11) default 1,
 	
 	PRIMARY KEY (`id`),
 	UNIQUE KEY `value`
-- 
cgit v1.2.3

