background preloader

Articles

Facebook Twitter

Lifehacker, tips and downloads for getting things done (Build 20. PKMN - Definition by AcronymFinder (Build 20100401080539) Create modern Web sites using HTML5 and CSS3 (Build 201004010805. Before you start This tutorial assumes some basic experience with HTML, CSS, and JavaScript. It assumes that you are aware of what an HTML element or tag is, what an attribute means, the basic syntax of HTML markup, the general structure of a Web page, and so on.

In terms of CSS, you are expected to be familiar with element, class, and ID-based selectors, the syntax of a CSS property, and how to include CSS in your Web pages using inline or external stylesheets. Finally, it is assumed that you have some working knowledge of JavaScript, such as what a variable, function, if statement, and for loop is, as well as how to include JavaScript code in your Web pages. About this tutorial HTML5 is widely regarded as one of the most important new technologies scheduled to emerge in 2010, and there are already several books being written on the subject, some of which are due to be published as early as March of this year.

Prerequisites Back to top New features in HTML5 Semantic elements Figure 1. Radio Free World - Free Radio Stations Online TV Movies Videos L. 32 Tips To Speed Up Your MySQL Queries | AjaxLine (Build 2010040. If you are interested in how to create fast MySQL queries, this article is for you Use persistent connections to the database to avoid connection overhead.

Check all tables have PRIMARY KEYs on columns with high cardinality (many rows match the key value). Well,`gender` column has low cardinality (selectivity), unique user id column has high one and is a good candidate to become a primary key. All references between different tables should usually be done with indices (which also means they must have identical data types so that joins based on the corresponding columns will be faster). Also check that fields that you often need to search in (appear frequently in WHERE, ORDER BY or GROUP BY clauses) have indices, but don’t add too many: the worst thing you can do is to add an index on every column of a table (I haven’t seen a table with more than 5 indices for a table, even 20-30 columns big). If you never refer to a column in comparisons, there’s no need to index it.