Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

Table with searchable string column [message #4] Fri, 11 August 2006 06:16  vadim1508 Messages: 9 Registered: August 2006 Junior Member Hi, I have a table (about 5 columns), which is loaded once and never updated. One of its columns is string (titles up to 100 chars). The content of this column will be searched as the whole value (select * from books where title = 'Effective C++';) or as a single word (select * from books where title like '%C++%';). The table contains millions raws. Selects are done mostly on this string column. What is the effective design? Is creating index for my string column is sufficient? I am doing LOAD DATA LOCAL INFILE. What is faster to create an index while creating a table or first load data without index an only than create an index? Do I need index for all 100 chars, if most of the time I have no more than 30-40 chars? Maybe I need FULLTEXT index? Thanks a lot for your help! Vadim Report message to a moderator

	Table with searchable string column By: vadim1508 on Fri, 11 August 2006 06:16
	Re: Table with searchable string column By: Peter on Fri, 11 August 2006 06:29
	Re: Table with searchable string column By: vadim1508 on Fri, 11 August 2006 11:34
	Re: Table with searchable string column By: Peter on Fri, 11 August 2006 11:39
	Re: Table with searchable string column By: vadim1508 on Sat, 12 August 2006 09:26
	Re: Table with searchable string column By: Speeple on Sun, 13 August 2006 08:32
	Re: Table with searchable string column By: Peter on Sun, 13 August 2006 09:26
	Re: Table with searchable string column By: vadim1508 on Sun, 13 August 2006 10:17
	Re: Table with searchable string column By: Peter on Sun, 13 August 2006 11:08
	Re: Table with searchable string column By: vadim1508 on Sun, 13 August 2006 11:20
	Re: Table with searchable string column By: Peter on Sun, 13 August 2006 11:32
	Re: Table with searchable string column By: vadim1508 on Sun, 13 August 2006 11:48
	Re: Table with searchable string column By: Peter on Sun, 13 August 2006 11:58

Previous Topic:	Joining many Tables vs. executing many queries
Next Topic:	Using Indexes to increase sort performance

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]