Tips and tricks to make kayako load faster

[jnet]

Any body can please share his tips and tricks to make kayako load faster?
mine seems to be very slow!

Thanks

[supportskins]

Use the "files" directory for attachments rather than storing them in the database.

[jnet]

thanks I have already done that any more?

[craigbrass]

Keep using the database optimisation tool inside Diagnostics inside the admin control panel.

[supportskins]

Run the maintenance wizard often to clean attachments from old tickets.

[jnet]

thanks and any less known tips or tricks?

Does Compress Desktop Application Output

and other copress

effect the speed of kayako?

[supportskins]

I would suggest you leave that as the default setting as it can increase server load.

[jnet]

thanks supportskins

you know what every thing seems to be fast except my kayako

makes me crazy

[supportskins]

What is your database size?

[jnet]

very small have just about 300 knowledgebase
I have not starting using kayako for support yet
still am working on design and filling up the knowldedgebase

[supportskins]

You might want to enable debugging to check why is Kayako taking so long to load. You can enable debugging by editing the config.php file.

[jnet]

Is this the code I have to change?

/**
* DISPLAYS EXACT SESSION EXPIRY REASON
*/
//define("DEBUGSESSIONEXPIRY", true);
/**
* LOGS ANY SQL ERRORS UNDER ./files/sqllog.txt - ENABLE ONLY TO DEBUG!
*/
//define("DEBUGSQL", true);
/**
* LOGS THE SLA DEBUG MESSAGES
*/
//define("SLADEBUG", true);

My kayako is very slow , I am really getting tired
is it because I use 3 templates?
I also have ssl

[John Haugeland]

You may also want to optimize table for your database tables, and consider installing a bytecode cacher such as APC.

[jnet]

John, Thanks I asked my server manager to install it but see his response


We have installed APC PHP cache in your VPS. The PHP info page 'http://domain.com/info.php' showed the APC module without any problem.

apc
APC Support enabled
Version 3.0.14
MMAP Support Enabled
MMAP File Mask no value
Locking type File Locks
Revision $Revision: 3.140 $
Build Date Jun 28 2008 13:45:54

But the kayako ticketing system installed in http://mydoamin.com/support was giving segmentation faults. So we have disabled the APC module by commenting the line 'extension="apc.so"' in '/usr/local/lib/php.ini'. It seems, there are some conflicts with kayako and APC. please refer, http://www.webhostingtalk.com/showthread.php?t=545059

Please check it from your end.


===
what should I do now?

[nocare]

hi,

we have an 1.2 GB big database and the same size of data in our files directory (summary: 2,5 GB of Space are used for kayako suppoersuite with avg 52 000 tickets). i cannot say that the supportsuite is slow. bit i read:

Originally Posted by jnet

We have installed APC PHP cache in your VPS

vps ? which dimensions of hardware has your vps ? perhaps the cpu and ram is to low for proper using ?

king regards,

nocare