I've been doing some benchmarking and the latest results I have show Links SQL capable of doing 16 queries per second, in a small database (1000 records) using a MySQL 4 DB, and a single CPU 1ghz machine. is this good compared to what other people have? I've benchmarking ASPSeek and it can do 50 queries per second in a database several times bigger (100.000) records. It is not perl, so I guess that's why it can handle loads better, but I would like Links SQL to have comparable performance to that of ASPSeeks' s 50 Queries per second. Can someone give me hints as of what else to do to enhance performance?
I've a dual Apache reverse proxy configuration, mod_perl and optimized http.conf files also the my.cnf MySQL file is optimized for high traffic, so I've already convered the 'obvious' stuff, is there any other tips on how to enhance performance? aditional fields to index? or 16 queries per second is simply the max I can achieve with my current hardware?
Thanks,
I've a dual Apache reverse proxy configuration, mod_perl and optimized http.conf files also the my.cnf MySQL file is optimized for high traffic, so I've already convered the 'obvious' stuff, is there any other tips on how to enhance performance? aditional fields to index? or 16 queries per second is simply the max I can achieve with my current hardware?
Thanks,