 |
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.
 |
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
| ||||||||||||
|
|
| | LinkBack | Thread Tools | Search this Thread | Display Modes |
(#16)
  |
| Member Posts: 43 Join Date: Jul 2006 |
13-10-2006, 06:25 AM
I have a small database 40Mb and I already optimized the tables and nothing has changed. I still have a total of 2000ms for 5 steps in kayako. |
| |  |
|
(#17)
|
| Senior Member  Posts: 3,962 Join Date: Aug 2006 Location: Mumbai, India |
13-10-2006, 08:29 AM
Quote:
Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support Our Skins and Services - http://www.supportskins.com/store/ SupportSkins.com - http://www.supportskins.com/ | |
| | |
|
(#18)
|
| Member Posts: 43 Join Date: Jul 2006 |
13-10-2006, 09:10 AM
They can't debug as I have the application in intranet and there is no access to it from outside  .I will have to dig every query and see what is happening myself I think...but this will take ages....and the sales department instead of moving my ticket to support kepps on buging me with upgrading to latest version... |
| | |
|
(#19)
|
| Member Posts: 46 Join Date: Mar 2004 |
14-10-2006, 12:28 AM
Just curious, which browser do you use? |
| | |
|
(#20)
|
| Member Posts: 43 Join Date: Jul 2006 |
16-10-2006, 08:58 AM
IE6 ...but some of my coleagues use Mozilla or opera and is the same rezult... |
| | |
|
(#21)
|
| Chief Executive Officer  Posts: 2,651 Join Date: May 2003 |
16-10-2006, 09:03 AM
You can try running the following SQL query to show all pending queries in queue: SHOW PROCESSLIST; That might clear it up, Did you try to repair/optimize your tables? It might be a case of corrupted index. Regards, Varun Shoor -------------------------------------------------------------------
|
| | |
|
(#22)
|
| Member Posts: 43 Join Date: Jul 2006 |
16-10-2006, 09:23 AM
I already optimized the tables, from admin. And show processlist didn't show anything out of the ordinary; a conection to kayako_suite (which disapeared a few minutes later) and the conection to anull db which must have been my query. I also enabled the logging but there are no slow queries . |
| | |
|
(#23)
|
| Chief Executive Officer Posts: 2,651 Join Date: May 2003 |
16-10-2006, 10:54 AM
As you are showing the server logs it cannot be something related to rendering for the browser. Anything in the error_logs which might point out something? Regards, Varun Shoor -------------------------------------------------------------------
|
| | |
|
(#24)
|
| Member Posts: 43 Join Date: Jul 2006 |
16-10-2006, 12:03 PM
No, the error log is empty...there are no errors just it loads very slowly... |
| | |
|
(#25)
|
| Chief Executive Officer Posts: 2,651 Join Date: May 2003 |
16-10-2006, 01:41 PM
Quote:
Perhaps you can try out the freely available profiling tools for PHP to see where the bottle necks are? http://xdebug.org/ is one. Regards, Varun Shoor -------------------------------------------------------------------
| |
| | |
|
(#26)
|
| Member Posts: 43 Join Date: Jul 2006 |
16-10-2006, 02:28 PM
Ok, I'll try to figure out how to use it and get back to you...until now I only manage dto get a CGi error by placing the line zend_extension_ts="e:\php_xdebug.dll in the php.ini... |
| | |
|
(#27)
|
| New Member Posts: 7 Join Date: Sep 2003 |
17-10-2006, 05:32 AM
I have pointed this to Varun years ago about the design of the MyDQL DB structure. The main table should be broken down into smaller tables rather than dumping everything into a single one which will become huge over time. This will result in slower and slower access time due to the large data table it has to search through. I wonder if they ever listen and do something about it after 4 years! Tom |
| | |
|
(#28)
|
| Member Posts: 43 Join Date: Jul 2006 |
17-10-2006, 06:38 AM
In my case is not a large database so this cause couldn't have been what is slowing us down. Anyhow xdebug doesn't work with Zend optimiser, so do what other tool I could use? |
| | |
|
(#29)
|
| Member Posts: 43 Join Date: Jul 2006 |
17-10-2006, 08:17 AM
It seems debuggers all want to rewrite Zend_extensions_ts, which if I do ten kayako won't work because of zend optimiser ...any suggestions? |
| | |
|
(#30)
|
| Member Posts: 43 Join Date: Jul 2006 |
18-10-2006, 09:08 AM
No suggestions? There is no profiler out there which is compatible with zend optimizer? |
| | |
|
| Tags |
| slow |
| Thread Tools | Search this Thread |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Open Criticizm - my overall Kayako experience | vinny | Comments, Questions & Feedback | 44 | 07-12-2007 10:29 AM |
| Huge Logic Bug/Hole on Piping and User Management on Kayako??? | iHubNet | E-mail Piping Issues | 5 | 12-04-2007 06:11 PM |
Linear Mode
