CPU usage

Hi everybody

in my bord all users use prillian to message. Usually i have 40-50 register user on-line that use this mod as a messanger. In 24h i have about 1000/1500 prillian private message + about 4000 in total (from the beginnin of the board) normal private messagge of phpbb. The refresh rate for prillian is 35 sec and i deleted the prillian message every 2 days

When i have about 20/25 register users on line my server go very very slow ...
Is possible that the lot of query to control new prillian message (25 users every 35 sec make a query to search new message in a total of about 5000/6000 records) can slowly the server performance??

Thanks Thoul for your help
Bye

I'm not very well versed in this field, but I imagine that would impact server performance. I don't think phpBB's private message system was really designed for that kind of load. If you can optimize your database tables on a regular basis, that might speed things up a little.

Thank's Thoul for your reply

I had tried to move the prillian message in another table.

First
I copy the structure of phpbb_privmsgs and phpbb_privmsgs_text tables and rename to phpbb_privmsgs2 and phpbb_privmsgs_text2

second
open include/constats.php and add
define('PRIVMSGS2_TABLE', $table_prefix.'privmsgs2');
define('PRIVMSGS_TEXT2_TABLE', $table_prefix.'privmsgs_text2')

third
open im_main.php and all related prillian file
and replace PRIVMSGS_TABLE with PRIVMSGS2_TABLE
and replace PRIVMSGS_TEXT_TABLE with PRIVMSGS_TEXT2_TABLE


but i have this error

Could not get list of messages

DEBUG MODE

SQL Error : 1146 Table 'mydomain.phpbb_privmsgs2' doesn't exist

SELECT pm.privmsgs_type, pm.privmsgs_id, pm.privmsgs_subject, pm.privmsgs_from_userid, u.username FROM phpbb_privmsgs2 pm, phpbb_users u WHERE pm.privmsgs_type IN (6, AND pm.privmsgs_to_userid = 7 AND u.user_id = pm.privmsgs_from_userid AND pm.site_id = 0

Line : 158
File : /var/www/mydomain.com/www/forum/mods/prillian/im_main.php


The query search for table mydomain.phpbb_privmsgs2 and not for table phpbb_privmsgs2 as define in includes/costants.php
Have you got any ideas for this strange error (i'm sute that the tables are correct).
Thanks

I'm not sure. It sounds like you did everything correctly. "mydomain.phpbb_privmsgs2" should just be another name MySQL uses for phpbb_privmsgs2.