The Successful Ingredients That You Need To Apply When Building A Website

April 9th, 2008 by gonomad70

The Successful Ingredients That You Need To Apply When Building A WebsiteSo you decided you wanted to build a website and now you are faced with all this information and you do not know where to start. Everybody online is promising the moon and stars and it’s almost impossible to tell which ones are genuine and which ones are not. A lot of these sales pitches make it sound like you can build a site go to sleep wake up in the morning to thousands in your bank account. So its time to step back from it all and take stock of your position as this will help clear your mind. What are you prepared to do. What are your strengths and weaknesses. Often times we run off and buy stuff and never think out how we can practically apply it. Remember information is one thing it is the application of information which becomes knowledge and this will provide you with a real experience. A real experience will provide real results.

A real experience will provide real results. The speed of implementation will bring about these results sooner rather than later. Where to start. Note down your interests and then visit article directories and forums and see how popular your subjects of interest are. From here you will get keywords and then you want see how often those keywords get searched. Keywords are your sites building blocks. If the building blocks are weak the overall structure will be weak. Take your time in the research phase as this lays the foundation. Don’t be afraid to deviate from your central idea especially if you find that a particular topic under the main subject seems to generate more searches and interest.

In other words be flexible. When it comes to building a site you can use a site builder. Just make sure they can build webpage’s that are structurally sound in terms of code and keyword density. Take care of the basics, keep it simple and your odds of success will be vastly increased. Watch These Free Videos At Site Build It Customer Reviews please allow time for the videos to load. Learn how to publish a real website That works Site Build It Review. Sign Up for the free affiliates masters course. Build It Customer Reviews. php: .


Unrelated, but we like plants:

 

 

 

 

 

Read the rest of this entry »

Website Development Should You Use A ‘Splash Page’ For Your Website? and keyword phrase

April 5th, 2008 by gonomad70

Website Development Should You Use A ‘Splash Page’ For Your Website. Some people say that using a splash page as your home page is a bad idea. And that’s true. You shouldn’t use a splash page as your home page for search engine optimization purposes. Search engines love content, and having a splash page as your home page defeats your purpose of ranking well in the search engines, if that is one of your goals. A splash page actually is a good idea if you don’t use it as your home page. For example, a splash page on a traffic exchange is an excellent strategy and it’s actually one of the best ways to eke out results from traffic exchanges. You can set your splash page as an extension. [continued…]


Related Posts:












You can set your splash page as an extension. For example, yourdomain. com/splash. html. Then use that for appropriate marketing channels. A splash page works well to get a visitor interested in a site because it’s consistent two step marketing. Get someone to do something, and he is likely to follow up on whatever you tell him to do next. So go and create a simple splash page now and use it for marketing channels like traffic exchanges, classified ads, pay per click ads etc. [continued…]


Technorati Reactions:














Splash pages are uncannily effective when the situation calls for something less cluttered and more attention grabbing. For the traffic sources mentioned above, splash pages definitely fit the mold. Hire a graphic designer to create a snazzy graphic for you to use on your splash page. After all, the goal of your page is to capture immediate attention. You can even create a simple Flash movie or even include a video there. Fabian Tan is the author of the free 51 Page Report:”Murder Your Job: How To Build Cash Sucking Autopilot Businesses In 30 Days Or Less. “Head over to to get your free copy now before it’s gone. : .












 

 

 

 

 

Read the rest of this entry »

The Successful Ingredients That You Need To Apply When Building A Website and keyword research

April 5th, 2008 by gonomad70

The Successful Ingredients That You Need To Apply When Building A WebsiteSo you decided you wanted to build a website and now you are faced with all this information and you do not know where to start. Everybody online is promising the moon and stars and it’s almost impossible to tell which ones are genuine and which ones are not. A lot of these sales pitches make it sound like you can build a site go to sleep wake up in the morning to thousands in your bank account. So its time to step back from it all and take stock of your position as this will help clear your mind. What are you prepared to do. What are your strengths and weaknesses. Often times we run off and buy stuff and never think out how we can practically apply it. Remember information is one thing it is the application of information which becomes knowledge and this will provide you with a real experience. A real experience will provide real results. [continued…]


Related Posts:












A real experience will provide real results. The speed of implementation will bring about these results sooner rather than later. Where to start. Note down your interests and then visit article directories and forums and see how popular your subjects of interest are. From here you will get keywords and then you want see how often those keywords get searched. Keywords are your sites building blocks. If the building blocks are weak the overall structure will be weak. Take your time in the research phase as this lays the foundation. Don’t be afraid to deviate from your central idea especially if you find that a particular topic under the main subject seems to generate more searches and interest. [continued…]


Technorati Reactions:














In other words be flexible. When it comes to building a site you can use a site builder. Just make sure they can build webpage’s that are structurally sound in terms of code and keyword density. Take care of the basics, keep it simple and your odds of success will be vastly increased. Watch These Free Videos At Site Build It Customer Reviews please allow time for the videos to load. Learn how to publish a real website That works Site Build It Review. Sign Up for the free affiliates masters course. Build It Customer Reviews. php: .












 

 

 

 

 

Read the rest of this entry »

Looking For A CSS Guide? Keep These 5 Major Points In Mind and keyword research tool

April 4th, 2008 by gonomad70

Looking For A CSS Guide. Keep These 5 Major Points In MindThe thing about computer languages is that there is some weird heaviness on the actual work involved. People are scared of by codes and although they see the power, they just can’t seem to get going because they have no idea where to start. That is where training comes in. And of course, fun training. You need to be taken by hand and shown exactly what you need to do, where you need to do it, and when you need to take the right action. The funny thing about CSS is that it allows you to create your website in the fraction of the time when you would do it using tables. It’s hard to believe, but still after all these years of promotion for CSS people (and companies. ) still heavily rely on tables for layout. They have no idea that they are simply wasting time on old techniques that will be useless in a matter of time. So where do you need to pay attention on when you are looking for a CSS Guide. 1. The TeacherThe number one thing you need to be sure of is that your teacher knows where he or she is talking about. Why is he or she teaching about Cascading Stylesheet, because they need to from their boss. Because they think they can teach, no matter the subject. Think of that, how many teachers are only “teaching” stuff, and never practice it their own. Ask yourself “why” are you teaching you me this. Are you the best in the field. [continued…]


Related Posts:












Are you the best in the field. Where did you get your knowledge from. 2. Teaching StyleSo the teacher may be a great person, has all the required skills, has a passion for the subject and knows about everything of it. But can your teacher deliver. Does he or she KNOW how to explain things. How to take you by hand and show you step by step how things work. Is it fun to follow along with the teacher. CSS is one of those topics that can become boring easily when it’s only discussed in a technical way. Make sure you know what you can expect. An even more important thing is cutting right to the case. You don’t want to end up with all kind of knowledge that you will never use in practice. It simply isn’t useful to learn every possible css style there is when you just get started. And this brings us to the third point you need to pay attention on when you are looking for a css guide. 3. Teaching / learning speedCan you keep up with the course. Does your teacher decide the speed, or do you. Of course a great way to follow a course is one that allows you to define your own speed. [continued…]


Technorati Reactions:














Of course a great way to follow a course is one that allows you to define your own speed. Home study courses and guides are wonderful for that. 4. DeliveryHow is your guide delivered. Are you somebody that likes to read, follow along with a training video or both. Decide what you like, training videos are great, because they allow you to follow along in a real life situation. This means hands on practice, which is exactly what you need if you want to become good in CSS. 5. ContentsLast but not least, content. What is discussed in the guide. What is marked as important. Do you get a total reference, or do you know you don’t need that, that the real thing you need is a hands on course with day to day subjects. Decide what you want to know, just the basics, how to create full layouts, or just how to create a menu using 100% CSS. It’s up to you now, decide what you need, you know how important the 5 above points are, and where you need to pay attention on. And one last tip, make sure you get some preview videos or sample chapter before following any course, it can save you a lot of time and money at the same time. Hilco van der Meer CSS ExpertHilco van der Meer is the creator of several CSS Courses. He teaches CSS in a fun way to companies and regular people that are looking for the best material available. More information about his latest courses can be found at Source: .












 

 

 

 

 

Read the rest of this entry »

Using Perl To Convert Hyperlinks And Filenames To Lowercase and finances keyword

April 4th, 2008 by gonomad70

Using Perl To Convert Hyperlinks And Filenames To LowercaseLike a lot of web developers, I’m not always that disciplined when it comes to the file naming convention I use and I sometimes end up with a situation whereby I have some files that are in lowercase, some that begin with a capital, and some that are a bit of a mixture. One web site I maintain contains about 2000 web pages and has about 20,000 hyperlinks. As you can imagine, I had one of those sinking feelings when I was told that in order to migrate the web site to a new content management system, all the file names and hyperlinks would need to be changed to lowercase. Whenever I am presented with a problem like this, my instinct is always to write a Perl script using one or more regular expressions to solve the problem. This particular situation was no exception. Change a string to lowercaseThe following regular expression changes all the characters in a string to lowercase. [continued…]


Related Posts:












The first part of the regular expression finds a hyperlink, and the second part converts the string. (Just in case this article is not displayed correctly, there should be a single backslash in front of the ‘L$1′). 1. $line =~ s/Change a filename to lowercaseLikewise, changing a filename itself is very simple. The following two lines perform the task quite nicely: 1. use File::Copy; 2. [continued…]


Technorati Reactions:














move (”$name”, “L$name”); (Again, there should be a single backslash in front of the ‘L$name’. )If you need more information on how to incorporate the above code snippets into a complete script, feel free to contact me directly. About the Author: John Dixon is a freelance web developer working for My Health Questions Matter, a company that helps users of the health service to ask the right questions in their dealings with health professionals. John is also interested in computer history and maintains a Computer History web site. Through his own company John Dixon Technology Ltd, John does web development work for various companies. : .












 

 

 

 

 

Read the rest of this entry »

Learning to Build Websites The Easy Way and generator keyword

April 4th, 2008 by gonomad70

Learning to Build Websites The Easy WayMost beginners get screwed up when it comes to website building. Often than not, this is what exactly holding them back to make money online. If you are one of them, let me tell you one thing for sure; building websites is not as difficult as what you might think. Well, I am not saying that it is just a piece of cake either, but learning to build websites worth the investment and effort. This article is about that, learning to build websites the easy way; much easier than you might ever think before. Easy Website ThemeEveryone knows something about anything, including you. This can be your passion, hobby or experience from the job. You will get nothing if you keep that knowledge for yourself and even if you share them in the offline world. However, internet can be totally different. You can get paid for your knowledge sharing through various monetization plans. It works for me and will work for you too. But then you might ask, If building website is that easy, why most fails building a successful website. [continued…]


Related Posts:












The answer is simply because, they fail to recognize and act upon the significant difference between offline and online trade. In the Internet, people look for information through Search Engine (SE) and web pages that ranked in the first page will benefit the most. Therefore, it is critical for you to optimize your web pages for certain targeted keywords so that you can rank high in the SE Ranking Position (SERP). Easy Web Building ToolYou can build your website with other free website building software. Wordpress and Blogger are probably the most popular free web building tool available in the Internet. However, both offer less flexibility and professional looks since they are geared towards personal blog or online diary than for business ventures. Nevertheless, you can use both to get some feel of how to build a great website. In my opinion, you should consider buying advanced website builder if you are serious about making money online. These softwares offer additional features compared to free tools such as flexible web editing and built in SE Optimization (SEO) tools. The initial investment can be easily recovered by the earnings potential you will be getting. I prefer Site Build It as my web building tool. Easy Traffic GenerationTraffic is the one that will determine your success. [continued…]


Technorati Reactions:














Although the more traffic is better, nothing can beat the targeted one ever. Therefore, keep your marketing campaign to the most reliable and targeted sources so that you can enjoy very high conversion rate (percentage of visitors that turn to customers). Article marketing is free and among the most effective Internet marketing campaign. Since you are the master or the so called “guru” in your field, writing a good article should not a big deal at all. Keep on writing great contents to attract more traffic. Best of all, it works forever. Part from that, you can connect your website with others through some social networking. Networking builds relationship and trust, which then makes your monetization effort much easier. Are you ready to start learning to build websites the easy way. Find out how Site Build It able to build a profitable website without any technical knowledge in Site Build It Review And Don’t forget to claim your “The Webmaster Business Masters Course” at Download. html for free. : .












 

 

 

 

 

Read the rest of this entry »

Php An In Depth Look and keyword overture selector tool

April 3rd, 2008 by gonomad70

Php An In Depth Look What is PHP. PHP stands for PHP: HyperText Preprocessor, it is a server side scripting language, and as the name goes, it is to create dynamic and interactive Websites for your visitors. Maybe you currently make your Websites in HTML. HTML alone cannot create dynamic Web pages, HTML is clearly defined as a static language, as it is always static and mainly is used for structuring (or styling, in some cases) a document (or a Web page, if you like). What do we mean by server side scripting. You may already know, but HTML is a client side language, so the browser translates the HTML code into “bytecode” that the computer can understand, and so the computer translates bytecode into what we can clearly understand, text, for example. Server side scripting is a little different, a little bit more added to the story. As with PHP, server side scripting languages have an interpreter inside a machine, that translates the code (in our case, PHP code) to HTML code (that the browser can understand), and then the same process will take place with the browser translating the HTML code to bytecode, and so forth. With server side scripting languages, you don’t need anything adding to your browser or computer, as the interpreter inside the machine that hosts the particular Website does most of the work. What’s the fuss with server side scripting languages, then. The thing that makes server side scripting a must nowadays is because it can generate dynamic Web pages, but what do we mean by dynamic Web pages. Well, imagine you wanted to start a forum, and you used HTML. Okay, you used a form to submit the data and it is sent to your e mail address, and you have to edit the static Web page every time you want a new post added. That, to me, would be the most annoying job of creating a Website. [continued…]


Related Posts:












That, to me, would be the most annoying job of creating a Website. However, with PHP (or any other server side scripting language, for that matter), can be completely automated, and you’d not have to edit your file even once. The thing that PHP does, is sends the form data to a different page, saves it in “pre defined” variables (things that store a value), and using something called a “while loop” that continually loops all the posts saved in the Web page and that’s it. PHP stores the posts in a MySQL database (something that holds data, if you like, like member accounts, etc) and uses that as long term memory. But if we’re talking about server side scripting languages, what makes PHP different from the rest. Well, simply put, PHP is probably the best thing that has come into the server side scripting genre. If you have heard about other scripting languages like Perl or ASP/ASP. NET, you’ll come to find that they are extremely hard to learn from. Put it this way, the majority of Web developers that use ASP. NET, for example, are those who have come from a different programming background, like have known VBScript, or other languages that’s in relation to ASP. NET, the same with Perl. The difference between PHP and the rest, is PHP is incredibly easy to learn, especially for the newbies towards this industry, and PHP has took several steps to ensure an easy introduction to those newbies to the world of programming. Let’s do an example, lets see which is the easiest to understand, out of PHP, VBScript and Perl, by doing a simple “Hello World” program, that outputs text to a Web page:PHP:echo “This is some text that’ll be shown in a Web page. “;VBScript/ASP. [continued…]


Technorati Reactions:














NET:Response. Write(”This is some text that’ll be shown in a Web page. “);Perl: #. /usr/bin/perlprint “content type: text/html nn”;print “This is some text that’ll be shown in a Web page. “;Okay, now I am not going to say things like “well, obviously PHP is the easiest to understand” as obviously, we all have different preferences, but what I can say is, that they all do the same thing. Which seems the most logical to you. In my opinion, the two most logical ones for me is PHP and VBScript/(ASP. NET). Now it’s up to you which one you want to go ahead with, experiment which one is best for you, after all, we all have dfferent tastes. Good luck. Below are a few resources to get started with PHP:# w3schools. com# php. net# mysql. com: .

















































































































































































































































































































































































































































































































 

 

 

 

 

Read the rest of this entry »

Passing Parameters In A Data Table Using JSF and engine keyword search

April 3rd, 2008 by gonomad70

Passing Parameters In A Data Table Using JSFSome working knowledge of J2EE or JSF is assumed for this article. Like some of you I’ve been frustrated with this technology known as JSF or Java Server Faces. There are several different flavors out there that are built on the shoulders of JSF. For instance Oracle’s ADF (Application Development Framework). Oracle ADF Faces Components is a set of over a 100 JSF components that let you build a richer user interface for your Java EE applications. Oracle ADF Faces also includes many of the framework features most needed by JSF developers today. That is great, and in many ways it will make life easier to develop in a JSF environment. Some items you will find available in these “add on” packages have a real benefit. For instance, as of the date of this article, I was very surprised that a File Upload is a feature still not implemented in JSF in respect to using natural jsf tags. There are ways to accomplish this task in JSF but they are not native JSF approaches. The process is a “no brainer” in just about every other framework available today, including asp. net. Another simple task (I thought) was having a data table present the results of a query in an editable format. Possibly to update a user record or shopping cart. After working in other technologies it was very efficient to return a result set to a data table object and let that object take care of some of the trivial behaviors and characteristics of the table itself. When I started exploring JSF I was frequently and at every turn becoming more and more frustrated in trying to duplicate some of the most basic of processes similar to managing records through data tables. There are not a whole lot of resources out there yet on JSF although it is growing steadily, and I found that all too often the resources that I was finding on the internet either didn’t apply to the more simple tasks or the information was just completely wrong. One example of that was that it was stated in one article I read that you cannot use command buttons inside of a JSF data table. The recommendation was to use JSF hyperlinks instead when trying to perform an action from a data table due to a bug in the framework that prevented command button actions to fire if the button resided inside of a data table. [continued…]


Related Posts:












The recommendation was to use JSF hyperlinks instead when trying to perform an action from a data table due to a bug in the framework that prevented command button actions to fire if the button resided inside of a data table. At first I thought “you’ve got to be kidding me”. Then I remembered that I’ve been finding a fair amount of “bogus” information in regards to JSF development so I decided to do further research and discovered that information to be less than accurate as well. I simply had to find a way to populate a data table through a result set and get a command button to fire an action and pass all of the data in the data table to the backing bean to update the record. Multiple command buttons would exist as well as hidden fields pertaining to id numbers and so forth. Pretty basic stuff and we’ve all done it before with relative ease. It turned out that the solution was in fact a simple one. “Binding”. You’ve heard about it and read about it. But this approach was something a little different as far as I could find. Many of the blogs and articles that I read dealt with passing the values as parameters and following the steps to define the parameters in faces. config files etc. , then retrieving the parameters in a backing bean. Processing the passed data required another set of procedures to utilize mapping to each of the field parameters passed and then processing could begin. That seemed like a whole heck of a lot to me just to retrieve form data. Then it occurred to me that I should be able to “bind” a text field component on a page to a backing bean. Once it is bound then all I have to do is extract the data. And that’s all there is to it. My query returned results and pre populated a data table including text fields with the values of the query pre populated in the text fields. [continued…]


Technorati Reactions:














My query returned results and pre populated a data table including text fields with the values of the query pre populated in the text fields. Each one of those text fields was bound to a “HtmlInputText” type in my backing bean. It was not a String type like other approaches define. Doing that does require you to map parameters and populate that String variable through your set methods once the form is submitted. What I found is that if I bind my text field to a property of text field type that it solved my problem of passing values from a data table, and I didn’t have to define parameter fields anywhere in any xml file. Now that I had that figured that out I needed to figure out how to get the value of that property that I’ve bound my form field to, well why not getValue(). I personally hadn’t seen any examples online or in books for retrieving the value from a form binding it to the type of form element it was and simply use the getValue() to pull out the value of the object. Used like this getParameterFromForm(). getValue(). Let me clarify that I am NOT saying that trying this approach isn’t documented anywhere, I find it hard to believe that I’ve had some stroke of genius that no one has had before in the world of java, especially since I’m coming from . NET and ColdFusion. After doing that I no longer had any problems passing form data to my backing bean. I was able to dynamically populate data tables with any number of records including any number of command buttons within that data table and I didn’t have to concern myself with remembering to define parameters in any other areas of the application. So put simply you can bind your form fields to properties of the same type in your backing bean, and then extract the value of that object using getValue() if you prefer over utilizing parameter string mapping and similar approaches for processing form data. I found it to be easier and less time consuming which has costs associated to it as well. Ben Cortese is a developer and business analyst for the financial industry. Copyright 2008. Article can be reprinted as long as author credits are given and content remains unchanged and intact. : .

















































































































































































































































































































































































































































































































 

 

 

 

 

Read the rest of this entry »

Efficient SQL Databases and keyword selector

April 3rd, 2008 by gonomad70

Efficient SQL DatabasesDon’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 TypesWhen 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. NormalizationNormalizing 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: DateTime vs Timestamp fieldsThis 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. [continued…]


Related Posts:












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 possibleIn 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 LIKEIf 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. [continued…]


Technorati Reactions:














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. Gareth McCumskey works as the Systems Developer for Synaq, a South African based Linux support and services provider. He has been involved in web development for over nine years and programming since he was 13. : .


 

 

 

 

 

Read the rest of this entry »

Do You Want To Create A Website Or A Business Online? and Keyword optimization

April 3rd, 2008 by gonomad70

Do You Want To Create A Website Or A Business Online. This is a question you will have to address. Many folks just a build a website but do not think out why they are really doing it. As a result they don’t take it seriously and therefore they do not get serious results. This makes logical sense right. A website in and of itself means nothing unless it has visitors and achieves a certain objective. So you have to be clear what you want to achieve as this will help you focus on your research and build a site that can achieve your objective. [continued…]


Related Posts:












So you have to be clear what you want to achieve as this will help you focus on your research and build a site that can achieve your objective. Quality research will help you build a quality website. To build a business online you are going to have to build a relationship with your site visitors. You will need to show them how to connect the dots and you can only do this by providing valuable content that is benefit driven. Furthermore you are going to have to show them solid evidence of how your product or service can help them achieve results. Connecting the dots means moving them closer to their outcome. Once they can follow this and see how it will work for them you will naturally build credibility which will result in you having a profitable website. [continued…]


Technorati Reactions:














As mentioned when you build your site you want to clearly have your visitor’s objectives in mind so that you can address their concerns and overcome their objections. If you can help them achieve their goals it will be a win win situation for all parties concerned. Watch These Free Videos At Site Build It Customer Reviews please allow time for the videos to load. Learn how to publish a real website That works Site Build It Review. Sign Up for the free affiliates masters course. Build It Customer Reviews. php: .


 

 

 

 

 

Read the rest of this entry »