[thelist] Proper mysql datastructure for a fullt

[Trav]

Thanks for the reply,
I'll work on refining the table structure as you suggest and see how it goes.
Best,
Travis





> From: rudy at r937.com
> To: thelist at lists.evolt.org
> Date: Mon, 25 Jan 2010 13:28:21 -0500
> Subject: Re: [thelist] Proper mysql datastructure for a fullt
> 
> travis, there are so many ideas wrapped up in your one simple post, i don't
> know where to begin...  ;o)
> 
> first, it is apparent that you want multiple tags per title
> 
> thus, your table design needs to change, to incorporate a tags-to-titles
> table for the many-to-many relationship
> 
> as for fulltext searching, you are putting the cart before the horse if you
> want tags included, as tags are atomic values, not descriptive text
> 
> fulltext search is appropriate only on title and/or descr
> 
> luckily, mysql allows fulltext indexes only on individual tables, not joined
> tables, so you can't include tags after all
> 
> i realize this explanation was brief, let me know if you want any of it
> expanded...
> 
> 
> 
> 
> 
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt ! 
 		 	   		  
_________________________________________________________________