Just Host Web Hosting Help
Help Content Tagged Query - 5 results ![RSS](//tutorials.Justhost.com/help_media/rss.gif)
What is CPU Protection
Knowledgebase Article
381,705 views
tags: cpu database mysql optimize peak performance query script slow
![](http://tutorials.Justhost.com/help_media/views.png)
![](http://tutorials.Justhost.com/help_media/tags.png)
Optimizing MySQL: Queries and Indexes Article 1 of 4 Courtesy of: Ian Gilfillan Badly defined or non-existent indexes are one of the primary reasons for poor performance, understanding and then fixing
Optimizing MySQL: Queries and Indexes Article 3 of 4 Courtesy of: Ian Gilfillan Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example o
Knowledgebase Article
216,018 views
tags: cpu exceeded index indexes mysql optimize optimizing queries query
![](http://tutorials.Justhost.com/help_media/views.png)
![](http://tutorials.Justhost.com/help_media/tags.png)
Optimizing MySQL: Queries and Indexes Article 4 of 4 Courtesy of:Ian Gilfillan Most systems need to be highly optimized for selects - take a news site which performs millions of queries per day, but w
Knowledgebase Article
209,124 views
tags: cpu exceeded index indexes mysql optimize optimizing queries query
![](http://tutorials.Justhost.com/help_media/views.png)
![](http://tutorials.Justhost.com/help_media/tags.png)
Optimizing MySQL: Queries and Indexes Article 2 of 4 Courtesy of: Ian Gilfillan Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table w