I am using the time I alloted today to work on the real estate investor marketing in the Learn To Be Rich on-line game to lay out a framework of the steps we need to follow to get this new feature implemented into the game.

First, I will need to access the Php MyAdmin control panel and manually add in some of the sample types of marketing so that I begin to play with those with my test player in the game. My intention is to add 3 or so different ones like classified ads, bandit signs and door to door flyers.

Next, once I have those three in the database, I will need to add some code so that there is a chance each turn to learn that from our in-game Marketing Consultant. This includes adding the type of marketing to that players database table as something that is available. It also includes making sure that it shows up on the Real Estate tab as something you can work on.

Once I have it in the players database table, I need to add the code for the player to be able to modify how much to spend each turn on that type of marketing.

Next, I will need to write the code to determine the number of new houses that appear for you to look at based on the marketing you are spending money on.

Once I have this basic system working, then I will go back and add more types of marketing and tweak the interface to get the right balance in the game.

So, that is the plan right now to make the game have that new feature for modeling the marketing to find motivated sellers.

Web site builders are online tools which anyone can use to build a professional looking Web site without programming and have it hosted instantly. No software to buy, no code to learn, all you need is to be a little Internet savvy and know how to click your mouse.

Most business owners today know that having a web site is an essential component of marketing. In the past, the choices were to hire a professional web designer, hire a local teenager to create a site for mall money, or learn to do it yourself. Often the last two options, which were the least expensive, were how small businesses had to go. The results are often not what businesses need to grow, reach, and impress new potential customers.

If you operate, manage or are the owner of a business, you surely must realize the increase in e-commerce taking place today. Many businesses find themselves searching for the best way to increase their exposure on the internet, and for most a website is the first course of action. As most businesses operate on firm budgets, finding cost effective solutions are usually one of the first thoughts when looking to make new purchases. When it comes to creating a website there are many affordable software programs that can produce professional results. Business software should be capable of handling your needs today and in the future. Business are always changing, adding new products, changing or removing old products, offering specials, having sales, etc. By choosing a business website builder over a professional web designer you will be able to make changes to your website whenever you want to. Another benefit is that you will be avoiding the high costs associated with developing the website and costs for making any necessary changes.

Website Builder tools advantages to you are increased revenue, cost control, caters to the large demand existing for web designing in the SME sector and can increase the client base without adding to your overhead. The advantage that your customers gets is a professional quality website, up and running in minutes and a User friendly and easily customizable interfaces and gives a complete website with all its frills and features and Sleek and attractive professional designs.

As more and more people are starting their own small/home business many are finding that having a website is an important factor to consider. When one starts to consider building a website, especially the novice, many questions arise including.... can I create a website myself or should I hire a professional?

Hiring a professional is a great way to go if you can afford to. Although there are several things to keep in mind: how much will it cost; how much will ongoing maintenance cost; what will changes cost; how long will changes take, etc. As a result, many people opt to build their own website and begin searching for software that can easily help them.

As you start searching for an easy web site builder, there are some factors that you should take into consideration so that your new software will serve you now and the future.

One of the first things to consider is your computer ability. If you despise computers and software and find them confusing and frustrating then building your own website can be quite a task, one that you may not want to finish. However, if you enjoy working with computers and learning new things or if you just have the patience to stick with it, then building a website is within your grasp. If you still feel that you want to build your own site you should choose software that is easy to use and user friendly.

There is quite a variety of easy web site building software on the market today. In addition, some of the software available today is very expensive, geared more for the professional web designer, and come with a huge learning curve.

A very important factor to consider, one that will vastly improve the ease of the program, is whether or not it includes a WYSIWYG editor. WYSIWYG stands for "what you see is what you get" and if you purchase a product with this feature you will be creating your website in an environment similar to a word processor - so if you are comfortable using a word processor creating a website shouldn't be too much for you.

In the past, the options for small businesses to get a site developed have changed dramatically. There are now sophisticated "site builder" tools available to small business owners, bundled with many web hosting packages. By using templates, and a content management system to manage updates to the site, it became easier to set up and maintain a web site, and many development companies have canned this functionality, for a fee. Hosting providers are increasingly offering tools to automate the web site building process, and with good reason. This new option has many benefits, as long as the business owner recognizes that there are trade offs and limitations to getting a web site this way.

One of the biggest attractions for site building tools is the cost. It won't necessarily cost less to get your site this way, but it does provide a way to spread the cost over time.

Many people are concerned with building their own website, fearing boring designs and complexity. However, it is now becoming apparent that there are many custom web site builder software products on the market that promise dynamic layouts, professional templates, and user friendly web design tools. The professional web designers know there are a few more things to know, but sometimes they find some irony in the fact that web developers, in their quest to improve and better the web, have made themselves "optional". Most site building tools today are very robust, making it simple to add forms, searching, maps, guest books, calendars, and a whole variety of elements to a web site. Even better, the hosting company sometimes offers an entire suite of services - the site builder, email marketing, search engine optimization and statistics, all in one package along with the hosting.

So, why would anyone hire a professional? First, the site building tools, though increasingly robust, often lack in design and layout flexibility. For example, they might depend on a standard layout that has a banner across the top, menu down the side. If you want to have your navigation across the top and perhaps a sub banner under it, you might not have that option. Many businesses have already outgrown their first or second site, and want something customized to their business. Since all site builders differ, it is possible that you could want features and functionality within your site which is not available within the system. Still, some site builders support development languages like PHP, making it possible to customize the site with the help of a programmer. Some site builders include ecommerce, but they do not all do it the same way. A few utilize PayPal® - but not credit cards. Some use a proprietary payment processing service and won't accommodate anything else. The bottom line is that it is important to look at sites that were built using the tool you're considering and research all of the features that are included; to be sure that everything you want to do is possible.

There is also a possibility that the service will require you to keep some branding on the site telling people that you used their tool. This is more common with the free site builders - which pay for themselves by putting ads on your site. If your goal is to build a business web site, it's really not worth sacrificing your professional image by getting something free, which screams CHEAP.

A tool can make things happen - but if you don't know what to make happen, it is either a useless tool or a dangerous one. There is a learning curve to knowing how to present information online (called information architecture in the profession), as well as for using the site builder. In other word, the fuller featured the tool; the more there is to learn. If you aren't familiar with color theory, use of typography, information architecture, navigation and interface design, page layout and design, you can potentially make something that will hurt your business more than help it. So, unless you are already computer and web savvy, figuring out all the features within your web hosting and site builder package can be time consuming and frustrating.

Fortunately, there are ways that a small business can take advantage of these new options and still create a functional and professional web site. One way is simply to take the time to research the available tools, and find the one that has the most features and flexibility, meeting your functional requirements. In other words, spend the time to learn the things a seasoned pro would bring to the table. The internet is a massive library of "how to" information, where you can literally teach yourself anything - and with enough time spent, you could potentially learn how to layout information, what colors and fonts work well together, how to conduct your marketing online and optimize the site for search engines.

Another approach would be to hire a professional designer simply to get you "off the ground" by handling the administrative set up of your new site package, creating the look of the site and developing the initial structure. That person could also teach you how to manage the content and make changes by yourself going forward. This middle ground approach ensures that your site benefits your business and makes a good impression. Depending on whether you use an editing tool or a site builder, you may still be able to take advantage of "pay as you go" pricing and the easy content management features of a site builder.

The first step for a small business owner thinking about having a web site needs to be an honest assessment of how much time, money, talent, patience and computer savvy he or she has, with a clear understanding of the available options. Once this is determined, any small business which needs to be online can be.

In addition, most dynamic website building software programs incorporate other useful tools that aid in the construction of a impressive site layout. Many programs include an html editor, text editor, and a WYSIWYG editor, making it easy for the novice or professional to achieve great results. There are many important factors to consider when purchasing an html editor / website builder. On of the most important benefits, in my opinion, is selecting software that can handle your ever growing business, today and in the future.

Don't be fooled by seeming simplicity. A lot of developers get comfortable with a certain way of designing a database for their web applications that they miss out on techniques they should rather employ to make things run faster and more efficiently. A lot of developers don't bear in mnd that the small site they are creating now might grow into something incredibly large and complex, and the database they designed has become bloated and doesn't scale well to meet the demands of the increased traffic.

This article hopes to provide web developers with a few techniques to help make their database and queries faster and more efficient.

1. Avoid Character Types

When you are designing a database, it is so easy to set all data types to the VARCHAR type as it can then contain any data you want; numbers or text. But character data is amongst the most inefficient data type you can get. If a field is only going to contain numbers, then make it one of the appropriate types (INT, DOUBLE, etc).

Also, wherever possible in your web development code, try to use numeric data types as opposed to characters. One of the most common things a script has to store are flags like whether someone answered yes or no to a question, etc. You could of course store it as 'Y' or 'N' but why not store it as 0 and 1?

The reason this makes a difference is when you have a database, for example, with over 500 000 entries, and are running a SELECT on that field, comparisons are processed a lot faster for numeric data types than character types. Also, if you need to return data to the calling script, numeric data is less memory intensive than character data. In addition, your web development language (PHP, ASP, etc) would also be able to process and perform functions on numeric data better than character data.

I am not trying to convince you never to use character data types. Sometimes it is a necessity, but if you can find ways to reduce the amount of character data processed by your SQL database, the better your server will cope.

2. Normalization

Normalizing a database is really quite a complex process. It is a process that describes a way to design a database structure to avoid repetition of data in your database and can lead to significant performance benefits if employed correctly. However, the entire process of normalisation is a bit beyond the scope of this article as it can fill books on its own, but any developer designing a database should seriously consider becoming knowledgable about normalisation and employing it in their own designs.

For a good tutorial on this process: http://www.keithjbrown.co.uk/vworks/mysql/mysql_p7.php

3. DateTime vs Timestamp fields

This actually relates to 1. a bit. The big difference to bear in mind here is that a field of type DATETIME is actually stored as a series of characters. A field of type TIMESTAMP is actually stored as an integer. So therefore, a more efficient way of storing dates is using the timestamp method. The timestamp has its drawbacks however. For one, you cannot store a date early than 1 January, 1970. Also, timestamps in your script will need recalculating to get to the character format. Because of this recalculation, it may not be better to store as timestamp. It really is a case of testing which format works better for your needs.

4. Use LIMIT where possible

In your queries, if you are doing a SELECT to a database and you only expect a certain number of results, using the LIMIT statement can speed your query up incredibly.

For example, if you have a table of users and you need to run a query to search for one users record, you can use a query like:

SELECT user_name FROM users WHERE user_id = 453;

This query is perfectly valid and will return the right result. But you also know there will only be ONE result. The query above will search the database, find what you want, but then still continue searching after that. It would run a lot faster if you could tell the query that once it has found what you are looking for to stop searching. LIMIT can do this, as this query shows:

SELECT user_name FROM users WHERE user_id = 453 LIMIT 1;

Imagine this scenario. You have a table called logins, that records every login from a user. It currently contains over 2 000 000 records, and you want to find the first time a user logged in. Now bear in mind that because this table inserts data over time, it is already sorted for by date. You could do the following query:

SELECT MIN(login_date) FROM logins WHERE user_id = 4876;

This will return the record you want, but SQL will now have to get all dates for that user, sort them and then return the lowest value to you. Our table is already date sorted simply because of the way it records data for us. So using LIMIT can be more effective:

SELECT login_date FROM logins WHERE user_id = 4876 LIMIT 1;

Because it is sorted, the first one will always be a users first login.

5. Avoid using LIKE

If you have tried to employ 1. above, then hopefully you will be in a scenario where you do not need to use LIKE all that much. LIKE is one of the most inefficient ways of searching a table. LIKE performs a text comparison search in a field and with no wildcards is as efficient as a direct comparison; i.e. WHERE name = 'Jane' is equivalent to WHERE name LIKE 'Jane'. It is when you start introducing the wildcard characters like '%' that things get really hairy.

If you do have to use LIKE, then at least try and make efficient use of the wildcards. These are '_' (underscore) and '%'. Let me explain all this with a real world example.

In a project I was involved in, we had a SQL database storing logs generated automatically from a mail server. Unfortunately, the mail server pretty much just dumped a very long string of text data into a field that contained the data we wanted. A script had to be written to find all logs that referred to a login by a user into the POP server. The only way we could do this was to search every record for a string in the msg field that had the text "User logged in" in it. The first query developed was something like this:

SELECT msg FROM logs WHERE msg LIKE '%User logged in%';

This query took on average of about 35 minutes to process. Obviously not an ideal situation. The way the LIKE worked here was that it had to parse through every single portion of each and every record in the msg field looking for text that matched "User logged in" anywhere in the text. We were able to determine eventually that the text "User logged in" occured at the end of that text in the msg field and so we altered the query:

SELECT msg FROM logs WHERE msg LIKE '%User logged in';

The '%' at the end was removed as we do not want to worry about text after because there is none. The query now only compares text to our string in the msg field at the end of the field and no longer parses through the entire piece of text stored in msg. The query now ran in under 2 minutes. (This was actually still too long, but how we optimised from there is a little beyond the scope of this article.)

Hopefully with all these elements put into practice on your next web development project, you can have a database that runs quickly, efficiently, uses as little resources as possible and wont grind to a halt when the load suddenly increases.