student
03-28-2007, 03:14 AM
hello,
I have a doubt.
I have orizinally declared the fields in my table like this:
...
title varchar(200) default NULL,
description text,
keywords text
details text
....
But I have limited 'description' and 'keywords' to 300 characters each and 'details' to 1000 characters in my php script.
Now, shall I change it like this:
...
title varchar(200),
description varchar(300),
keywords varchar(300),
details varchar(1000),
....
I have a fulltext index on these fields and I wish to optimize my table for good performance.
please inform me how should I declare my fields.
thank you.
I have a doubt.
I have orizinally declared the fields in my table like this:
...
title varchar(200) default NULL,
description text,
keywords text
details text
....
But I have limited 'description' and 'keywords' to 300 characters each and 'details' to 1000 characters in my php script.
Now, shall I change it like this:
...
title varchar(200),
description varchar(300),
keywords varchar(300),
details varchar(1000),
....
I have a fulltext index on these fields and I wish to optimize my table for good performance.
please inform me how should I declare my fields.
thank you.