do I need to use fulltext search for one column?

[Join us @ facebook]

Sure you can post it

The tutorials area is only viewable by the members anyway

[Free WordPress Themes]

Now I have splitted the domain in the columns:
sub_domain
domain
tld

do I have to set indexes for all three columns?

[Join us @ facebook]

You need a primary key for all of those (check them all together and add primary key from phpMyAdmin)

[Free WordPress Themes]

got an error because the entries are not unique sinds I have records for different image sizes for the same domain name... do I have to change that?

[Join us @ facebook]

I don't got that. You keep for each domain one photo?

If you do then all 4 fields must be kept as a primary key.

[Free WordPress Themes]

I don't got that. You keep for each domain one photo?

If you do then all 4 fields must be kept as a primary key.

yes I save max 4 thumbs for each domain (Chris is using two formats)

Now I understand how this works with the primary index, thanks (these 4 columns are the values I use to select a thumbnail)

[Join us @ facebook]

these 4 columns are the values I use to select a thumbnail

That's the point. You got it

[Guest]

[44.249]

Googlebot, Msnbot, Baidu Spider, Yahoo crawler