• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Meta data search database

Drakkon

Drakkon

Diamond Member
Attempting to build up a database of data with specialized information and one key field will be for meta data. In the long run want searches to be optimized so people just search for a term and will bring up all images with that term.

So if data is in a mysql database - what are the best methods to deal with the data? I know i could create a relational table that could store 1 entry per row for each meta tag or similarly relate it back to comma separate values for each meta tag. Are there any advantages to using one way over the other?
 
I would expect 1 entry per row would end up being many times faster, simply because of the ability to index it more effectively.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top