Use indexed views to increase the speed of your queries

bbrown

This is a nice tip for a pure SQL enviroment, but I'm not sure how applicable it is for C/Side. Also there can be a trade-off to indexed views. While they can improve read performance on specific queries, this comes at the cost of needing to maintain them during the write process. Overusing/misusing indexed views can be just as bad as not using them.

David_Singleton

bbrown wrote:

... but I'm not sure how applicable it is for C/Side.

who said it had anything to do with Navision

this user is basically a bot. There are a whole lot right now testing the security of mibuso. My web site (wiki.dynsamicbook.com) is also being hit at the moment by what looks like a similar spammer.

FYI this text is just copy pasted from http://www.databasejournal.com/features/mssql/article.php/1437361/SQL-Server-2000-Optimization-Tips.htm

garak

thats the 5th post where i know it's from a bot......

David_Singleton

There are a lot more than five. What is odd is that some of them (like the michelle bot) are actually doing something, in this case creating a link to that hr page to help Google rankings. But a number of the others are just testing. Those are far more dangerous because once they are safe they will come back and do damage. Most likely edit the user profile or the thread itself with viagra advert. I had a few of these a few months back and just ignored them, and now they are everywhere on my wiki. Damn I hate these people.