Re: Apache / PHP/ MySQL - user limits

Ian Robinson wrote:
Hi,

I'm new to web server development and am wondering if I have chosen correctly for a planned development of moving a desktop application to a web server environment. The desktop application is an inventory stock control / invoicing program running on 200 desktops.

At what level of concurrent users do we start to meet limitation problems / performance hits

That depends ... set up correctly u probably wont run into performance issues.

Last week however someone asked me to look at a system php/mysql system performing badly. As it turned out one query had multiple joins on different field types (x.id (int(11)) = y.id (varchar(255))). As a result a single query took over 3 seconds where after fixing this it took it's normal 0.00x seconds.

A few years ago, as an experiment, I set up a fulltext index on a table with over 500.000 text rows (hehe). An insert on that table then took me over 15 minutes :-)

So without knowing exactly what you want to do, the source code and the database design I cant really help.

Arjen
.