- for a FREE 30-Day Trial

WebProWorld Dev Forum

Bulk Mail Script in ASP
I am sending email newsletter to my clients about 6000 using ASP mail object. I am writng my own script. Now i have an issue which is script performance or speed.
Click to read more...

How do I get everyone to see my site full screen
My site on my Computer is full screen and I seen it on some others some are full and others are not. I heard I have to program it to be visible on other computers to be full screen is that correct and if so how do I do it?
Click to read more...

Alternative to Yahoo Click Trails
I want to deliver more detailed analysis to a client about their paid-inclusion campaigns. A friend was showing me Yahoo's Click Trails for his store, but alas, my client isn't a store and doesn't want to spend $99 a month to set up a non-store on a store account.
Click to read more...


Recent Articles

Sun Trying Something New ... Like Giving Away An Operating System
Sun Microsystems is trying a new marketing strategy, giving away its new Solaris 10 operating system for free.

MySQL Database Handling in PHP
Most interactive websites nowadays require data to be presented dynamically and interactively based on input from the user. For example, a customer may need to log into a retail website to check his purchasing history. In this instance, the website would have stored two types of data in order for the customer to perform the check - the customer's personal login details; and the customer's purchased items.

Developing State-enabled Applications With PHP
Installment 1 Developing State-enabled Applications With PHP

Programming Auto-apply in Accounts Receivable
Microsoft Great Plains is one of three Microsoft Business Solutions mid-market ERP products: Great Plains, Solomon, Navision.

Navision Customization: Business Notification – tips for Programmer/IT Specialist
Microsoft Business Solutions Navision is one of four Microsoft ERP applications: Navision, Axapta, Solomon and Great Plains. Navision has huge market share in Europe and becomes more popular in US, especially for Manufacturing companies.

Understanding GRML
HTML is the primary markup language used on the web. After its first release, it lacked many of the features taken for granted today on the web. It took many years for HTML to become what it is. In fact, almost four years passed between the first attempts at a markup language and HTML 2.0. In the years since 1995, HTML has continued changing. This demonstrates the commitment necessary to develop a markup language.

11.17.04

Generate HTML Files With PHP To Reduce The Server Load

By Bobby Handzhiev

PIM Team Case Study

How can you have a site with tons of visitors without to crash the server?

Problem

PIM Team Bulgaria had the task to create a quiz site able to hold an extreme server load.

The site is currently installed as beta version at www.quizzy.net.

Goals

- Create a user friendly quiz editor

- Create static URLs for the quizes

- Users were able to put the quizes on their site. However this shouldnt cause big server load.

Solution

Creating database structure and the basic program logic was a game play for the experienced developers in PIM.

However we had to decide the best way to reduce the server load. After investigating together with the help of the customer we found the best solution - the quiz forms were going to be hardcoded.

Methodology

We don't need anything special except PHP and MySQL to achieve this task. Having the right permissions to write in the server folders its all about generating strings and saving HTML files.

Implementation

As this article is not aboput creating a quiz site, we'll point our attention only to these features which required reducing of the server load.

A quiz editor for creating and editing quizes

While the creating of quizes isnt likely to be done by all the users of the site all the time, we wouldnt need to worry about the server load. Not that we can hardcode this editor in HTML ever!

The editor allows usres to create questions with various number and type of answers on each quiz.

Each quiz also had various number of results which were generated depending of user's answres.

Here we saw what we could use to reduce the server load:

Web Customer Support - Complete solution automates email, FAQs, ticket tracking, more --> try it now

Quizes themself

What is one quiz in the terms of a website? Its just a HTML form. However our users are creating the quizes so nobody could know what forms will they create. The ordinary solution is to read the database with questions, select possible answers and display them to the users.

But all of this is database queries. We can't select questions and answers at once with JOIN, because both need to be ordered in the same way the user has put them in the editor.

This means at least one query for each question. Imagine a quiz with 30 questions taken from 100 users at the same time. This is 3000 queries at least. We don't wan't to do this.

So we were going to create pure HTML forms from the quizes at the time of creating. We also needed to update the quizes when users update them. So we add a button 'activate' for 'sending' the quiz online. Hitting this button actually takes the questions and answers from the database and creates HTML form. Below is a piece of code showing how easy this is:

Read the Rest of The Article.


About the Author:
Bobby Handzhiev is a senior developer in PIM Team Bulgaria

http://pimteam.net

admin@pimteam.net

About DevNewz
DevNewz has assembled experts around the world to deliver helpful advice to application developers. Our in-house news staff focuses on keeping you updated with the latest new software and trends in application development. DevNewz provides Knowlege For Application Developers.

DevNewz is brought to you by:

SecurityConfig.com NetworkingFiles.com
NetworkNewz.com WebProASP.com
DatabaseProNews.com SQLProNews.com
ITcertificationNews.com SysAdminNews.com
LinuxProNews.com WirelessProNews.com
CProgrammingTrends.com ITmanagementNews.com


-- DevNewz is an iEntry, Inc. publication --
iEntry, Inc. 880 Corporate Drive, Lexington, KY 40503
2004 iEntry, Inc.  All Rights Reserved  Privacy Policy  Legal

archives | advertising info | news headlines | free newsletters | comments/feedback | submit article

Knowlege For Application Developers DevNewz News Archives About Us Feedback DevNewz Home Page About Article Archive News Downloads WebProWorld Forums Jayde iEntry Advertise Contact