ASP, CGI and PHP Scripts and Record-Locking: What Every Webmaster Needs To Know

Written by Sunil Tanna

Continued from page 1


Of course, avoiding having your data corrupted should berepparttar paramount consideration in choosing a script, but is there anything else we need to be concerned about?

Answer: Performance

Of course, all webmasters are aiming to build busy high traffic web sites... but will your scripts be able to handlerepparttar 143660 load?

Go back and re-readrepparttar 143661 paragraph on file-locking. Now think about what would happen if allrepparttar 143662 classified ads on your classified page were stored in a single file (or allrepparttar 143663 links on your top site, or allrepparttar 143664 subscribers to your autoresponder, etc.).

What would happen?

Answer: Because each update can only be performed afterrepparttar 143665 previous update has been completely finished, your site may be slow, or even unable to handle all your users' requests.

So what'srepparttar 143666 solution?

There's two options that programmers can use:

1. They can use lots of small files and file-lock each individually (for example, one per classified, one per top site listing, etc.). Of course, this needs to be handled very carefully...

2. They can use a database (like MySQL), as databases allow any one individual record ("row") to be updated, even when another is also being updated.


Now, let's summarise:

1. Scripts that store data in files need to use file-locking to avoid data-corruption, and they also need to breakrepparttar 143667 data into separately updateable chunks to avoid performance problems on busy web sites.

2. Scripts that store data in databases (like MySQL), provided of course that they have been properly coded, are usually less likely to suffer from data-corruption or performance problems.

And one additional point:

3. Evenrepparttar 143668 best script is not immune to hard-disk hardware failures, your web host being struck by lightning, and allrepparttar 143669 other snafus that can happen. So, do take regular back-ups of any data that you can't afford to lose!

In short, even if you're not a script programmer, you need to be aware of data storage issues. In future, when considering a script for your web site, don't be afraid to ask some hard questions about how it stores data and how well it handles multiple users.

This article is Copyright (C) 2005, Answers 2000 Limited.

Aboutrepparttar 143670 Author: This article was written by Sunil Tanna of Answers 2000. For a directory of ASP, CGI, PHP and Remotely hosted scripts, please visit - and for scripts written by Answers 2000 please visit ----------------------------------------------------------------- -----------------------------------------------------------------

Publication Terms And Conditions:

Answers 2000 Limited grants you a free non-exclusive permission (license) to publish a copy of this article on your web site or opt-in ezine, subject to you complying with ALL ofrepparttar 143671 following:

1. You must publishrepparttar 143672 article in full and unedited (except that you may omit this Terms and Conditions section, you may omitrepparttar 143673 word count, and you may correct any typos that you might find). 2. If you publish on a web site: (i) you must make ALL links clickable, (ii) you may formatrepparttar 143674 article to fit within your web site's design, (iii) you must includerepparttar 143675 copyright notice and "Aboutrepparttar 143676 Author" section atrepparttar 143677 end. 3. If you publish in an ezine: (i) your ezine must be opt-in with your users having specifically elected to subscribe to your ezine and withrepparttar 143678 ability to unsubscribe at any time, (ii) you must include all link URLs unedited and in full, (iii) you may formatrepparttar 143679 article to your ezine's layout, (iv) you must includerepparttar 143680 copyright notice and "Aboutrepparttar 143681 Author" section atrepparttar 143682 end. 4. Torepparttar 143683 maximum extent permissible under law, this article is provided "AS IS" without warranties of any kind whether express or implied. 5. These terms and conditions shall be governed by and construed in accordance withrepparttar 143684 laws of England and Wales. Any disputes arising from matters relating to this article shall be exclusively subject torepparttar 143685 jurisdiction ofrepparttar 143686 courts of England and Wales. You agree that any legal action against Answers 2000 Limited (or its directors, officers, or employees) relating to this article or this agreement will be brought inrepparttar 143687 courts of London, England, however Answers 2000 Limited reserves right to pursue breach of these terms in any jurisdiction.

There are 1225 words in this article (including title and Aboutrepparttar 143688 Author section).


This article was written by Sunil Tanna of Answers 2000. For a directory of ASP, CGI, PHP and Remotely hosted scripts, please visit - and for scripts written by Answers 2000 please visit

5 CGI Scripts You Must Use to Turn Your Site Into a Powerhouse

Written by Marc Goldman

Continued from page 1
should be using automated follow up mechanisms to: A. Capturerepparttar email addresses of targeted prospects interested in your products/services. B. Send a series of sequential, timed messages that trigger return visits to your website and turn potential onetime website visitors into return prospects. c. Remind customers about additional products and services that they may wish to order inrepparttar 107137 future or add to their current order. These are easy to maintain once they are installed on your site. All you have to do is writerepparttar 107138 email responses you want your prospects to receive and then upload them to your server. Then tellrepparttar 107139 script how long a time interval to wait before sending repparttar 107140 next message inrepparttar 107141 sequence. An important point when using follow up autoresponders: make sure they offer an unsubscribe feature so thatrepparttar 107142 recipients can opt out if they choose to. There are many great scripts out there that you can install on your own site. This will save yourepparttar 107143 monthly fees of using a hosted service but if you choose to use a third party tool, probablyrepparttar 107144 best one is available from getresponse: Number 5: An error catcher. This may sound like a crazy tool to include in this list but bear with me. How many of you have tried to click on a link and found yourself on a 404 error page. Most web surfers who encounter this error immediately leave your site never to return again.This is probablyrepparttar 107145 worst thing that could happen to an internet business. What if you could create a page that said, OOPS you reached this page in error but why not visitrepparttar 107146 rest ofrepparttar 107147 site? This is certainly more enticing and if created properly can help keep a surfer on your site as opposed to off it. On our site, we use a script that catches errors and delivers a webpage apologizing forrepparttar 107148 mistake and offering other links to pages on our site. We have saved many visitors this way and we have also created many subscribers and customers through this method. If you want to see how it works, try this link The script we used to create these pages is freely available and can be set to email you when someone reaches a 404 page and also help you determine if anyone is trying to hack into your site or if a CGI script is not working. It is called errorbot.cgi and can be found at These 5 scripts can make or break an internet business so why dont more people use them? I believe they don't have a clue how to install them. If anyone wishes to have CGI scripts on their site but needs help installing them, you can usually get help fromrepparttar 107149 programmer or visit a site like who will usually install scripts for a nominal fee. CGI scripts have been around sincerepparttar 107150 advent of commerce onrepparttar 107151 internet and continue to powerrepparttar 107152 best sites. Even with new technologies such as ASP, Cold Fusion and PHP onrepparttar 107153 rise, CGI isrepparttar 107154 oldest and stillrepparttar 107155 best. Why not get these 5 scripts running on your website and start powering your way to new profits.

Marc Goldman, Goldbar Enterprises Discover the exclusive members only website that will easily explode your traffic and increase your sales by thousands of dollars!!

    <Back to Page 1 © 2005
Terms of Use