On Mar 14, 2:13 pm, Geoff Cox <g...@freeuk.notcom> wrote:
> Hello,
>
> I am involved in a project which might have large numbers of people
> accessing the web site at the same time.
>
> The pages have javascipt code and also involve adidng/taking data
> to/from a MySQL database.
>
> Is it possible to load test the site in any way?
>
> Is it necessary to move the web site onto a non-host-sharing server?
> These are much more expensive but may be required?
>
> Are there any precautions required with accessing the database? Do you
> have to lock tables/records to prevent corruption?
>
> Any advice will be appreciated.

You may find the following books from O'Reilly helpful.

"Building Scalable Web Sites"
"High Performance Web Sites"
"High Performance MySQL"

I haven't read them they might get you on the right path.

Peter