Fires of Heaven Guild Message Board - View Single Post

Grooverider · 04-05-2008, 04:55 AM

Ok, so I construct the database like this:

[company list]
- {company id} - {company name in text}

[kw list]
- {kw id} - {word/phriase in text}

[log]
- {kw id, instead of kw list from text} - {company id, instead of company in text} - {various data} - {various data}

Now say I want to pull a list of phrases that the company is associated with in the database in the log. Would this be faster than my previous set up?

i.e. this time i'm doing a : search log for ID etc etc join the tables, or something?

04-05-2008, 04:55 AM	#11 (permalink)
Grooverider hildog Join Date: Aug 2002 Posts: 843 -1 Internets	Ok, so I construct the database like this: [company list] - {company id} - {company name in text} [kw list] - {kw id} - {word/phriase in text} [log] - {kw id, instead of kw list from text} - {company id, instead of company in text} - {various data} - {various data} Now say I want to pull a list of phrases that the company is associated with in the database in the log. Would this be faster than my previous set up? i.e. this time i'm doing a : search log for ID etc etc join the tables, or something?