I have just started my first big project and I am having trouble predicting
the system specs that will be required. At present during trials the site
has around 15 users, although this will go to 350 when it is launched.
Most of the pages execution time should not scale with the increase in users
but there are a few report pages which calculate and order the information
entered by the users.
Measuring the page on my development machine (Duron 1.2, 768MB PC133, WinXP,
running apache 1.3.22, mysql 4.0.15and php4.3.4)...
One page I am currently getting 0.2-0.3 seconds. It uses phplib templates
and it executes 9 queries at present, 1 of which I predict will scale. It
calculates the mean, standard deviation and total of around 90 measures
using results from 15 users.
I do have a few nightmare pages for the regular users which execute 150+
queries (mixture of selects and updates).
Can anyone predict what will happen with 300+ users?
I am thinking max load being 20 regular users logged in with 2 users viewing
reports.
The machine I am currently looking at is P4 2.4, 512DDR with Linux. Will
this be suitable?
Thanks for any help/advice you can offer..
Greg
2  1963  Can anyone predict what will happen with 300+ users?
I am thinking max load being 20 regular users logged in with 2 users viewing
reports.
The machine I am currently looking at is P4 2.4, 512DDR with Linux. Will
this be suitable?
I would need to see your "monster" pages, but I think you should be
okay. If you have that many queries on one particular page, it might be
time to start thinking about more powerful options than PHP.
Either Java or Microsoft products would allow you to embed your queries
outside your presentation layer, and optimize there.
However, if you're only talking 2 people viewing these complex reports
at a time, I think you're fine.
Lukas Can anyone predict what will happen with 300+ users?
I am thinking max load being 20 regular users logged in with 2 users viewing
reports.
The machine I am currently looking at is P4 2.4, 512DDR with Linux. Will
this be suitable?
I would need to see your "monster" pages, but I think you should be
okay. If you have that many queries on one particular page, it might be
time to start thinking about more powerful options than PHP.
Either Java or Microsoft products would allow you to embed your queries
outside your presentation layer, and optimize there.
However, if you're only talking 2 people viewing these complex reports
at a time, I think you're fine.
Lukas This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: dave |
last post by:
Hi there!!
I have one table with date field in sql server2000.
I want to write one sql query statement that fetch
last three months data from the current month..
Any help would be appreciated...
Thanx..
dave
|
by: Greg |
last post by:
I have just started my first big project and I am having trouble predicting
the system specs that will be required. At present during trials the site
has around 15 users, although this will go to 350 when it is launched.
Most of the pages execution time should not scale with the increase in users
but there are a few report pages which...
|
by: Sumanth Suri |
last post by:
Hi,
I want to setup one of the fields in a table so it increments
sequentially(int data type). i.e the first record should be record 1
and the second one should be 2 and so on. This field will also be the
key field. I am new to SQL and don't know how to do this.
I am using SQL server 2000.
Thanks for the help in advance.
-S
|
by: Owen Jacobson |
last post by:
We all know that text-align: justify; is supposed to justify the
block's text across the box. I have a friend, however, who wants to
take that further. A visual example, because it's 2:30 AM and I don't
want to try to describe it:
MARGIN| S O M E T E X T |MARGIN
Where "SOME TEXT" is a heading, presumably, and the spacing...
|
by: plaztik8 |
last post by:
Hello,
Can someone please help me with a query?
The table looks like this:
BookedRooms
===========
CustomerID RoomID BookDateID
| | |
by: Jeremy |
last post by:
I have built a form that calls queries. I have the first 2 set up as
select queries, and the third set up as a make table query. When
multiple users are on this application at the same time, they get
errors or the data is overwritten while they are sitting there. If I
do all select queries, 1. the records pop up if I use a "RUN" command...
|
by: Karen Hill |
last post by:
SELECT surgeries.*, animals.*
FROM surgeries INNER JOIN animals ON .=.
AND WHERE ((.=Date()) Or
.=Date());
I'm trying to write a query that joins two table together, animals and
surgeries where surgeries.id = animals.id and only where the surgery
date was date_a or date_b.
I'm doing this in Microsoft Access 2000 and am tearing out my...
|
by: Brian Tabios |
last post by:
Hello Everyone,
I have a very complex performance issue with our production database.
Here's the scenario. We have a production webserver server and a
development web server. Both are running SQL Server 2000.
I encounted various performance issues with the production server with a
particular query. It would take approximately 22 seconds...
|
by: MVM |
last post by:
Hi,
I am attempting to run a query in MS SQL server between two tables that have
a one to many relationship.
The tables are linked on GID. What I want is one instance of every record
from Table 1 even if there isn't a record in Table 2; and even if there are
multiple records in Table 2.
Table 1:
GID
Parcel
|
by: Roger Ineichen |
last post by:
Hi Tim
For a usecase like this, I personaly recommend to
defina all interfaces in one module which probably
is a namespace if you need alot of interfaces to define.
e.g.
openehr.interfaces.foobar.IFooBar
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
