Online entery form or upload the form

guywithLAMP

Dear All,
I am working on a project to host a website. The site will be having the data entry form of about 30 fields. The site is expected to serve around 3 lakh user in a month.
Please help me to minimize the load on the server. Using the online form for data entry is good or the download fill upload a document?. What other precautions I have to take before attempting it?

Prine

3 lakh? I assume you are from indoa or pakistan?

Thats 3 million in english i think.

Weedpacket

Three hundred thousand visits in a month is about one visit every eight seconds on average.

Roger_Ramjet

'Online form' is really download to client - fill in form - upload (POST/GET) to server.

So the 2 methods are equivalent - unless the online form is spread across multiple pages, in which case it is multiple forms with multiple downloads/uploads.

rsmith

I personally think an online form would be more simplistic and a lighter load. You simply have to fill in data, submit it, and insert the data to a DB. you could then format the data however you wanted for reports or e-mails etc. Having the user download a form, fill it out, and re-upload it is a longer process, mainly for the user. They have to wait for the form to download (server bandwidth issue), fill it out, and re-upload it (user bandwidth issue). Then you still would have to either store the form some place, e-mail it, or parse it to extract data and then insert into a db. So direct form entry though an online form seems more practical for me. You have more control over the presentation and manipulation of the submitted information.

Just MHO.

guywithLAMP

Thanks for the replay. My concern is as I said earlier, the page is accessed by around 3 lakh people in a month. Is there any problem with MySQL if multiple user [say about 10,000] try to update the db at a time? If yes how can I handle that load on the database ?