Here is my 2.0 update of perpective.php... I added the global declaration of $DB object and updated the DML_functions as described in http://docs.moodle.org/en/Development:DML_functions
Re: Performance perspectives - a little script
Thanks for the update. I tested it for fun (I'm aware of the limitations of this script).
Here are the results. VPS Ubuntu 10.04 with 2GB RAM (burst to 4.5GB) - 6 cores 2.4GHZ. Moodle 2.2.3
Moodle System Benchmarks Note for Moodle 1.7 and above: Disable the record cache (Site Admin -> Server -> Performance) for realistic results! | |||
---|---|---|---|
Processor performance | |||
Function calls | 3535000 | 3522000 | |
Regular expression replaces over 1KB of text | 20200 | 20200 | |
Disk performance | |||
16KB files read from disk (cache) | 77200 | 79100 | |
16KB files written to disk (cache) | 6300 | 6500 | |
Database performance | |||
Get_record calls on the course table | 6080 | 5930 | |
Insert_record calls on the course table | 1890 | 2490 | |
Update_record calls on the course table | 2330 | 6270 | |
Maximum concurrent users (approx): | 251 |
I have also done some JMeter testing - I am very happy with this little box
Cheers,
Fred
Re: Performance perspectives - a little script
Hi, I am trying to benchmark two installataions of moodle 2.3 running in amazon aws with rds. One its over apache and the other its over lighty.
But I cant make work the script, I tried just to copy to /mod/ but I cant make it work.
¿How does I install the script?
Thank you in advance
Re: Performance perspectives - a little script
I may be wrong, but I don't think that this script is usable anymore and hasn't been updated in quite some time.
Re: Performance perspectives - a little script
Re: Performance perspectives - a little script
The script only works with moodle 1.9 and below. The database calls need to be updated for Moodle 2.0 and above:
get_record('course','id',1) : $DB->get_record('course',array('id' => 1))
insert_record('course',$newrecord) becomes $DB->insert_record('course',$newrecord)
update_record('course',$newrecord) : $DB->update_record('course',$newrecord)
delete_records('course','id',$ids[$count]) : $DB->delete_records('course',array('id' => $ids[$count]))
$db->ErrorMsg() : $DB->ErrorMsg() - there's 4 of these
I think that's everything.