I have an IIS server with php 5 nand mysql 4. PIII w 1gb ram. I have around 300 users that need to login from their pcs in around 5 minutes. Now timetrex goes so slow the users take 10 minutes to signin. Some pages take minutes when everyone is using it. I have accessed the db with syqlog and can access the tables quickly when timetrex is slow. I can access the moodle websites on the same server, when timetrex is this slow and it is fine. Any suggestions?
Thanks bruce
Speed
Install APC (http://pecl.php.net/package/APC), upgrade your hardware or try moving to a Linux server. Windows and especially IIS can be slow without spending a lot of time tweaking it.
TimeTrex can handle between 3000-5000 employees on a Celeron 2.4Ghz with 1Gb of ram no problem.
TimeTrex can handle between 3000-5000 employees on a Celeron 2.4Ghz with 1Gb of ram no problem.
Speed
I now have a PIII with 1gb running fedora with apache and eaccelerator for caching. I tried APC but it was slower.
I still have performance issues
When I run ab I get
This is ApacheBench, Version 2.0.40-dev <$Revision: 1.146 $> apache-2.0
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright 2006 The Apache Software Foundation, http://www.apache.org/
Benchmarking www2.unicoischools.com (be patient)
Server Software: Apache/2.2.0
Server Hostname: www2.unicoischools.com
Server Port: 80
Document Path: /
Document Length: 3926 bytes
Concurrency Level: 1
Time taken for tests: 21.723380 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Non-2xx responses: 1000
Total transferred: 4123000 bytes
HTML transferred: 3926000 bytes
Requests per second: 46.03 [#/sec] (mean)
Time per request: 21.723 [ms] (mean)
Time per request: 21.723 [ms] (mean, across all concurrent requests)
Transfer rate: 185.33 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 19 21 8.5 20 182
Waiting: 0 20 8.9 19 181
Total: 19 21 8.5 20 182
Percentage of the requests served within a certain time (ms)
50% 20
66% 20
75% 20
80% 20
90% 23
95% 27
98% 35
99% 42
100% 182 (longest request)
When I use the system My requests shoot up to 35 seconds per page on the timetrex screen at the bottom.
I still have performance issues
When I run ab I get
This is ApacheBench, Version 2.0.40-dev <$Revision: 1.146 $> apache-2.0
Copyright 1996 Adam Twiss, Zeus Technology Ltd, http://www.zeustech.net/
Copyright 2006 The Apache Software Foundation, http://www.apache.org/
Benchmarking www2.unicoischools.com (be patient)
Server Software: Apache/2.2.0
Server Hostname: www2.unicoischools.com
Server Port: 80
Document Path: /
Document Length: 3926 bytes
Concurrency Level: 1
Time taken for tests: 21.723380 seconds
Complete requests: 1000
Failed requests: 0
Write errors: 0
Non-2xx responses: 1000
Total transferred: 4123000 bytes
HTML transferred: 3926000 bytes
Requests per second: 46.03 [#/sec] (mean)
Time per request: 21.723 [ms] (mean)
Time per request: 21.723 [ms] (mean, across all concurrent requests)
Transfer rate: 185.33 [Kbytes/sec] received
Connection Times (ms)
min mean[+/-sd] median max
Connect: 0 0 0.0 0 0
Processing: 19 21 8.5 20 182
Waiting: 0 20 8.9 19 181
Total: 19 21 8.5 20 182
Percentage of the requests served within a certain time (ms)
50% 20
66% 20
75% 20
80% 20
90% 23
95% 27
98% 35
99% 42
100% 182 (longest request)
When I use the system My requests shoot up to 35 seconds per page on the timetrex screen at the bottom.
Unfortunately performance tuning can be a quite involved process, especially on the older computers.
You can purchase a computer that could probably handle 3000 employees from DELL for about $500, I would recommend that route for best results.
If thats not an option you will either need to research proper performance tuning techniques for Linux, Apache, PHP, and MySQL, or pay someone to do it for you, which will probably cost more then a new server.
The fact that using APC slows things down tells me you're setup has some serious issues. Because APC eliminates the need to compile the PHP scripts at every page load, so in normal circumstances eliminating that process should never slow things down.
You can purchase a computer that could probably handle 3000 employees from DELL for about $500, I would recommend that route for best results.
If thats not an option you will either need to research proper performance tuning techniques for Linux, Apache, PHP, and MySQL, or pay someone to do it for you, which will probably cost more then a new server.
The fact that using APC slows things down tells me you're setup has some serious issues. Because APC eliminates the need to compile the PHP scripts at every page load, so in normal circumstances eliminating that process should never slow things down.
Everthing works great now.
Everthing works great now.