Tryangled Solutions web designing tips tricks

Often your choice of indices will make or break your database. For those who haven’t progressed this far in their database studies, an index is a sort of hash. If we issue the query SELECT * FROM users WHERE last_name = ‘Goldstein’ and last_name has no index then your DBMS must scan every row of the table and compare it to the string ‘Goldstein.’ An index is usually a B-tree (though there are other options) which speeds up this comparison considerably.

You should probably create indices for any field on which you are selecting, grouping, ordering, or joining. Obviously each index requires space proportional to the number of rows in your table, so too many indices winds up taking more memory. You also incur a performance hit on write operations, since every write now requires that the corresponding index be updated. There is a balance point which you can uncover by profiling your code. This varies from system to system and implementation to implementation.

<gmail.com>: Google’s attempt at free e-mail. Instead of the 2-6 MB of free space that Yahoo and Hotmail used to provide, Gmail gives you 2,600 MB (and growing) of space (this has already caused Hotmail and Yahoo to raise their amounts to 250 MB and more; AOL.com now gives you 2,000 MB free). I have been using it for 1.5 years and it’s terrific and fast. One caveat: Google runs small, text-ads on the side of the screen, based on content of your e-mail messages. That’s scary to a lot of people, though Google promises no human will ever see your messages, just those Google servers (remember, however, that all e-mail can potentially be scanned by various systems). I don’t use it as my primary e-mail. I use it in two ways, with two accounts. One is an account to which I send messages, photos, PDFs, I want to save for future access, including big messages that I don’t want taking up space in my regular inbox - kind of a “greatest hits” collection. The other is an account that get a copy of every e-mail message I get, so that it’s all backed up and available in one place.

If you’ve ever tried to display an image with your text wrapping around it, you have probably discovered it won’t work with just a plain image tag.

To do so, you must include the ALIGN attribute within your image tag.

Image Displayed on Left:

<IMG BORDER=”0″ ALIGN=”Left” SRC=”yourimage.jpg”>Your Text

By placing the above code within your HTML, your image will be displayed on the left hand side with your text displayed on the right.

As you continue to type your text, it will automatically format itself to wrap around the right side and the bottom of your image. This example has been set up with a table to keep the text neatly aligned within a limited amount of space. The table’s width is set up to span 50% of the page width.

Image Displayed on Right:

<IMG BORDER=”0″ ALIGN=”Right” SRC=”yourimage.jpg”>Your Text

By placing the above code within your HTML, your image will be displayed on the right hand side with your text displayed on the left.

As you continue to type your text, it will automatically format itself to wrap around the left side and the bottom of your image. This example has been set up with a table to keep the text neatly aligned within a limited amount of space. The table’s width is set up to span 50% of the page width.

start regedit,
add/update value “NoLowDiskSpaceChecks” to DWORD = 1
path: HKEY_CURRENT_USER -> Software -> Microsoft -> Windows -> CurrentVersion -> Policies -> Explorer
requires a logoff or reboot

du -h /home/user | sort -n -r > disk_usage.log
-h - gives results in KB/ MB etc.
redirecting the output helps later inspection because if you have many folders you won’t be able to see the folders that take a lot of space.

Be sure to make your content scannable. Few website visitors actually read blog posts; most web visitors simply scan a blog entry to determine its relevance or point. With that in mind, the blog posts should be displayed in short paragraphs. Overly long posts should be segmented into concise paragraphs or broken into bulleted lists to make scanning easier. Avoid the urge to “clutter” the post.

Every hosting account has a certain allotment of disk space. The disk space is used to hold all the files which make up your web site – HTML files, graphics, scripts, and multi-media content. Usually the more expensive the hosting package the more disk space and the more bandwidth you receive.

A basic web site with just a few pages requires less than 1 MB of disk space. As you add more content and include things like downloadable files, pictures, music, and video you will require more disk space. Email also takes up disk space. If you have an account with a small disk allotment you may find that unsolicited SPAM may be eating away at your disk allotment. It’s always a good idea to go through your inbox from time to time to delete unnecessary emails.

What will happen if you use too much disk space? Each web host has their own policy about this but it’s safe to say that you will be charged for the extra space. Often this penalty is much higher than regular rates for disk space so it’s important to keep an eye on how much space you are using and if you are approaching the limit, either purchase more space or delete some files.

How can you tell how much space you are using? Most hosting packages have a control panel for making adjustments to almost every aspect of your account. These control panels usually tell you how much disk space is being used and may also rate it against your allotment so you can see at a glance if you are approaching your limit. If your hosting account does not have this feature you can judge the amount of space by downloading your entire site to a folder on your personal computer in order to check how much space it takes.

As a rough guide, consider that an average web page (3 graphics and 2 screen lengths of text) takes about 20 kb (to be generous). At this rate, a hosting package with 10 MB can have about 500 pages. Since most small sites are less than 50 pages 10 MB should be plenty to get started. But what about databases? They are usually calculated separately from your disk allotment but check with your web host to see what their policy is.

If you place music or video files on your website your need for disk space (and bandwidth) starts to take off. A typical 3 minute MP3 file takes about 2.5 to 3 MB of disk space. A short video (very poor quality) can take 1 MB. A good rule of thumb for those wishing to host multimedia is to estimate the total size of the files and get an account with double that space. This will allow for future expansion. Always check with your web host, though, before placing sound or video files on your website. Some have policies against this type of content because it places a strain on the bandwidth allotment – a serious consideration with a shared hosting package.

One of the fastest growing sectors of the Internet is eCommerce. People are becoming accustomed to buying things from Internet store fronts and every year the volume and value of sales increases substantially. If you would like to open up your own eCommerce web site here are a few basics to get you started.

The first thing you need, obviously, is a product or service that you can sell. If you already have a brick and mortar store you can offer the same items for sale on a web site. The number of products that you sell is a big factor in the type of hosting package you need. If you have let’s say less than 20 items, you could set the whole thing up on a very small hosting account. Listing hundreds of products is a different story – you will probably need more disk space, more bandwidth, and more features such as databases and a secure connection for accepting payments.

Since the most important part of eCommerce is getting paid, let’s look at the various payment options available. There are two basic options – collecting payment information directly or hiring a third-party service to process credit cards.

Not every post is worthy of making it to the top of Digg, Del.icio.us/popular or even a mention at some other blogs in your space. Trying to over-market every post you write will result in pushback and ultimately lead to negative opinions about your efforts. The less popular your blog is, the harder it will be to build excitement around a post, but the process of linkbait has always been trial and error - build, test, refine and re-build. Keep creating great ideas and bolstering them with lots of solid, everyday content and you’ll eventually be big enough to where one out of every 20-40 posts really does become linkbait.

Some memes are worthy of being talked about by every blogger in the space, but most aren’t. Just because there’s huge news in your industry or niche DOES NOT mean you need to be covering it, or even mentioning it (though it can be valuable to link to it as an aside, just to integrate a shared experience into your unique content). Many of the best blogs online DO talk about the big trends - this is because they’re already popular, established and are counted on to be a source of news for the community. If you’re launching a new blog, you need to show people in your space that you can offer something unique, different and valuable - not just the same story from your point of view. This is less important in spaces where there are very few bloggers and little online coverage and much more in spaces that are overwhelmed with blogs (like search, or anything else tech-related).
-