Tryangled Solutions web designing tips tricks

MySQL has two primary storange engines: MyISAM and InnoDB. Each has its own performance characteristics and considerations. In the broadest sense MyISAM is good for read-heavy data and InnoDB is good for write-heavy data, though there are cases where the opposite is true. The biggest gotcha is how the two differ with respect to the COUNT function.

MyISAM keeps an internal cache of table meta-data like the number of rows. This means that, generally, COUNT(*) incurs no additional cost for a well-structured query. InnoDB, however, has no such cache. For a concrete example, let’s say we’re trying to paginate a query. If you have a query SELECT * FROM users LIMIT 5,10, let’s say, running SELECT COUNT(*) FROM users LIMIT 5,10 is essentially free with MyISAM but takes the same amount of time as the first query with InnoDB. MySQL has a SQL_CALC_FOUND_ROWS option which tells InnoDB to calculate the number of rows as it runs the query, which can then be retreived by executing SELECT FOUND_ROWS(). This is very MySQL-specific, but can be necessary in certain situations, particularly if you use InnoDB for its other features (e.g., row-level locking, stored procedures, etc.).

Mozilla’s Firefox 2.0 for Windows has garnered praise from critics since its late 2006 release and, aside from some undesirable security flaws, has pretty much lived up to expectations. The browser’s strong following can be attributed in part to its passionate developer community, which continues to churn out some very impressive browser add-ons. With some of these add-ons, also known as extensions installed, Firefox can become somewhat of a powerhouse application.

Add-ons and extensions aside, Mozilla’s browser stands up pretty well in its native form due in large part to some key features.

Google Analytics is a great program that can do a lot more than most people realize. Here are a few features that you may not know about:

* Capture internal search stats. This is a newer feature of Google Analytics and a very nice one. Not only can you see what a visitor put into your internal search box, but what page they were on when they made the search and what page they chose in the search results. Any internal search will work as long as it passes the search variable through the URL. Here’s a short video interview with Google’s Brett Crosby on some of those features.

* Filter out domains. Let’s say your Google Analytics code somehow got on another site and your stats were getting tainted with irrelevant data. No problem. You can create a filter to not count anyone from specific domains you add in. Oddly enough, you can also filter out your own domain so your stats flat line. Not a good idea to do that though.

* Track document downloads or specific links. Adding a small piece of JavaScript to any link will tell Google to track when someone clicks on that link. This works for PDFs, Word documents, email address’ and external links. It also works if you want to see which two links on the same page are generating more clicks. Even though they go to the same URL, you can tag one link as ‘link one’ and the other as ‘link two’ and Google will track the clicks separately for you. Bonus Tip: If you have a Wordpress blog, you can instantly tag all links across your blog with the Ultimate Google Analytics plugin.

* Export to Excel. For any newbies, this is a time saving feature. Just about any report can have the data exported to a CSV file which Excel can open. You can now stop copying and pasting most data out of Google Analytics and into Excel and save yourself some time.

* Filter yourself out. This feature is a must do for any company. Find your static IP address and then set up a filter so Google knows not to include traffic from your company network. This ensures that your stats are not inflated due to employee’s surfing habits. This also is something you should consider for any partner companies. If you have a web development, or SEO company who is constantly checking out the site, filter them out too.

“I can find what I need on Google” – Is this a common refrain amongst staff
and students in your college? Whilst Google is certainly far and away the
most commonly used search engine currently available, it is often not used in
the most effective way. There are many useful extras in Google that are
under-used, but which go towards making it a far more complete and effective
search tool than you would imagine. Here are some of the more interesting,
useful and quirky features that you might like to explore in order to get more
out of Google

1. Keyword Searches, no one can beat Google Analytics and Google Adwords, so in this case most SEO tools will never live up to the standards, they just don’t have the information.

2. SERP (Search Engine Result Pages), to see progress, we have to see our rankings even if they are not in the top 50. So instead of sitting their and clicking on Google and hitting next an SEO tools should have ranking checkers.

3. Submission Tools, automated submission should be done at a minimum, but having a tool do it for you is a lot easier.

You have decided that a dedicated server offers the best features for your online presence. There is no need to share resources and you can set up the server as you please. There remains just one question: Are you going to rent or buy your server? Dedicated hosting means that you are renting a server from a web host. But you also have the option of buying your own server and having the host provide the facilities to house it and connect it to the Internet. This service is called colocated hosting.

The advantages of colocating include all the advantages of dedicated hosting – you have the resources of the entire server and bandwidth to do with as you please. The additional benefit over dedicated hosting is the lower cost. Because you own the server, your monthly fees don’t include charges for hardware maintenance and upkeep. On the other hand, your initial outlay will be larger because you have to buy the server. If the server is good quality and remains in service for a reasonable length of time, however, your overall costs will be lower with colocation.

The cost of colocation depends on the amount of space your server occupies. Data centers house servers in racks that in turn are housed in cabinets. Cabinets are usually 40 rack units in height, with each rack unit equal to 1.75′. The cases of server computers are measured in rack heights – 1U = 1.75′. Typical sizes for servers are 1U, 2U and 4U, so the physical size of your server will determine how much the colocation host will charge per month. Bandwidth is another factor affecting price.

There are several options available when purchasing a server and getting it to the colocation data center. If you live in close proximity to the data center you could buy a server locally and set it up at your own premises. Once it is setup you can personally deliver it to the data center. Another option is to buy the server from a mail order retailer and have them deliver it directly to the data center. This is a good option if you are not located near the data center. It saves you the cost of shipping the server and the retailer will be responsible if the server happens to be damaged in transit.  The disadvantage is that you have to set up the server remotely through a web interface. The third option is to buy the server direct from the host. Not all hosts are in the business of selling servers, but those that do may offer financing and setup assistance.
Colocation or Dedicated?

Colocation puts you in charge of the hardware, but that also means that you are responsible in the case of hardware failure. If you have signed up for dedicated hosting you are renting the server, so the host will replace hard drives or CPUs if they malfunction. The initial costs of colocation are much higher than dedicated hosting. You have to buy the server as well as insurance and software licences. All that is included in a dedicated hosting plan. Hardware upgrades are also more expensive with colocation because you have to buy the new equipment outright and pay to have it installed. Dedicated hosting plans usually allow you to upgrade either hardware or bandwidth at a reasonable cost.

The main advantage of colocation is the lower monthly costs when compared with dedicated hosting plans. Other advantages include greater control over network configuration and more flexibility. A colocation provider has to be chosen carefully. After all, they will host both your hardware and your data. Consider such details as security, network redundancy, protection from fire and earthquakes, and backup generators in the case of power outages.

Microsoft Internet Explorer 5 has several hidden features which can be controlled using the Windows Registry. Open your registry and scroll down to the following key:

HKEY_CURRENT_USER\Software\Policies\Microsoft\Internet Explorer\Restrictions

Create a new DWORD value named x(See complete list of values of x below) and modify it’s value to 1 to enable it and to 0 to disable it.

NoBrowserClose : Disable the option of closing Internet Explorer.

NoBrowserContextMenu : Disable right-click context menu.

NoBrowserOptions : Disable the Tools / Internet Options menu.

NoBrowserSaveAs : Disable the ability to Save As.

NoFavorites : Disable the Favorites.

NoFileNew : Disable the File / New command.

NoFileOpen : Disable the File / Open command.

NoFindFiles : Disable the Find Files command.

NoSelectDownloadDir : Disable the option of selecting a download directory.

NoTheaterMode : Disable the Full Screen view option.

Soon i will come up with a new whole range of tricks on iE. Till then enjoy this one.

MySQL will start offering some features (specifically ones related to online backups) only in MySQL Enterprise. This represents a substantive change to their development model — previously they have been developing features in both MySQL Community and MySQL Enterprise. However, with a shift to offering some features only in MySQL Enterprise, this means a shift to development of those features occurring (and thus code being tested) only in MySQL Enterprise.

Firefox 3 Release Candidate 2 is available in more than 45 languages as a public preview release intended for developer testing and community feedback. It includes new features as well as dramatic improvements to performance, memory usage and speed.