sitepoint.com sitepoint.com

Secrets to Site Search Success

Most of us use the search box on an ecommerce site to find the product or service we want — if we can find a search box, that is. When we do, most search attempts will yield either no results, or too many irrelevant results. Forrester reports that 93 percent of ecommerce sites either don’t provide site search facilities, or use software that fails basic tasks. Jupiter MediaMetrix reports that: "80 percent of online...

databasejournal.com databasejournal.com

More on Indexes - Page 2

Some knowledge of how indexes work allows you to use them more efficiently. Firstly, note that when you update a table with an index, you have to update the index as well, so there is a performance price to pay. But unless your system runs many more inserts than selects and the inserts need to be quick, and not the selects, this is a price worth paying. What about if you want to select on more than one criteria? (As you can see,...

databasejournal.com databasejournal.com

Leftmost Prefixing - Page 3

Ordering by surname is a common requirement, so it would make sense to create an index on surname. But in this example our employee table consists of thousands of people from Swaziland, and with the surname "Dlamini". So we need to index on firstname as well. The good news is that MySQL uses leftmost prefixing, which means that a multi-field index A,B,C will also be used to search not only for a,b,c combinations, but also A,B as...