Forum Moderators: open
mysqld
VIRT: 134m
RES: 29m
%CPU: 200
%MEM: 4.4
TIME+ 82:07
That is of course A LOT of usage. The 10K users request a JSON file to their mobile phones every 5 minutes (that xml can be empty or with messages).
How could i improve this issue?
BTW, i use:
PHP5 + Adodb for PHP
Here is the connection code:
include(DIR_LIB.'adodb/adodb.inc.php');
$cnn = &ADONewConnection(DB_TYPE);
$cnn->cacheSecs = (86400);
$cnn->debug = false;
@$cnn->Connect(DB_HOST,DB_USER,DB_PASS,DB_NAME);
(i recently switched from PConnect to Connect to see if it helps to reduce the overload a little).