I need to store search keywords in a database to analyse user needs. How efficient should my schema be?
I'm thinking like this:
CREATE TABLE SearchKeyword ( ID INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, UserID INTEGER, SearchKey VARCHAR( 255 ) NOT NULL, Date TIMESTAMP NOT NULL );
But with this, the table will grow. Any suggestions for improvements?