I know FULLTEXT catalogs and how to use them. They are faster than the LIKE clause, especially when used on longer text fields, but still much slower than a search in a numerical field. Keeping the catalog up to date also hurts performance. Luckily this is only needed when inserting/updating/deleting something. That is why I prefer searches in numerical fields wherever and whenever possible. When I design a database, I only create fulltext indexes on large textfields like the contents of a post, not on small ones like a title field. Depending on the database engine and full text catalog engine, the performance break-even point between WHERE - LIKE and FULLTEXT lies between about 50-500 characters in the text field. As for the trolling issue: here's how I see it. Whatever feature is included, there will be some aholes that will abuse it. By stripping away the feature, the aholes win. They have managed to cripple the service/product. And the normal, responsible users lose. This seems to be a fact of life. Not only on Renderosity, it happens everywhere, both online and offline. Letting a**holes win is against my religion. That said, I'm not pleading for a "no holds barred" type of site. Reasonable restrictions and safeguards are absolutely necessary. A little example: On preventing burglary. You can leave all your doors and windows wide open. That will make it very easy to enter or leave the house. Very functional and user friendly, but also very unsecure. You can fill up your entire house with concrete. Impossible to break into, but your house will also be totally useless. Or you can install and use decent locks. This will keep most burglars out, and you can still enter or leave your house without too much trouble. I have the impression that renderosity is leaning towards filling the house with concrete. And williamsn: thanks. It's good to know that the issue is not being ignored.

The pen is mightier than the sword. But if you literally want to have some impact, use a typewriter

My gallery   My freestuff