|
|
Posted by Arjen on 03/29/06 13:45
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
Navigation:
[Reply to this message]
|