Author Topic: Speeding up FENG?  (Read 14483 times)

Murz

  • Full Member
  • ***
  • Posts: 147
    • View Profile
Re: Speeding up FENG?
« Reply #15 on: July 11, 2011, 09:16:26 am »
Here is chart for opening task page process on demo site: http://wstaw.org/m/2011/07/11/plasma-desktopNT3057.jpg - 2.62 seconds.
It is not slow, because demo have not many projects and tasks.
And here is chart for opening task in our system: http://wstaw.org/m/2011/07/11/fo1.jpg - 5.48 seconds.

System have about 100 projects and 4000 tasks, 100 documents, 200 notes, 10 tags.

So, as you see, 1830 ms (milliseconds) spend to generate first page (index.php) and other - for JS and AJAX requests:
Total JS: 652 ms
Total AJAX: 4267 ms (4 seconds!)

Slowest JS: 145 ms - load language translate strings
Slowest AJAX: 2239 ms - //?&ajax=true&active_project=23&c=task&a=view_task&id=483&utz=4&current=overview-panel&_dc=1310385308612 (load current task with id from url)

Next slowest AJAX: 957ms - load tags with number counts.

Task page ajax load process started only after 3.13 seconds after page load started.

So, if we start load task at first page load (without ajax), we will render page (to see the task) with the 2.5 seconds instead of 5.48 - more than 2 times speedup.

To load CSS we spend 595 ms, to JS - 635 ms, so combining and compressing js and css will increase page load time by 0.2-0.5 second maximum (because after this we must spend time to pase js and css anyway).

Tests are done with Chrome browser, so every user can repeat it in his system and detect slowest parts of page rendering process.
« Last Edit: July 11, 2011, 09:22:08 am by Murz »

nicname

  • Freshman
  • *
  • Posts: 35
    • View Profile
Re: Speeding up FENG?
« Reply #16 on: July 11, 2011, 09:42:38 am »
I know this was just an answer to the statement that css and js loading takes a lot of time. time

Of course this doesn't affect the server load, but if you use feng over a small bandwidth connection it helps,
I only use JS combining because css combining destroys my own stylesheets.



Murz

  • Full Member
  • ***
  • Posts: 147
    • View Profile
Re: Speeding up FENG?
« Reply #17 on: July 11, 2011, 09:49:17 am »
I know this was just an answer to the statement that css and js loading takes a lot of time. time

Of course this doesn't affect the server load, but if you use feng over a small bandwidth connection it helps,
I only use JS combining because css combining destroys my own stylesheets.
As I see in logs, JS and CSS loads from server only at first page load time, all other times they loads from browser cache. So, users got slow load only on first login in browser, and all other times (next day, week, etc) css and js will loads locally from browser cache.

nicname

  • Freshman
  • *
  • Posts: 35
    • View Profile
Re: Speeding up FENG?
« Reply #18 on: July 11, 2011, 10:06:32 am »
which is exactly what you said in your last post  ;)

Murz

  • Full Member
  • ***
  • Posts: 147
    • View Profile
Re: Speeding up FENG?
« Reply #19 on: July 13, 2011, 05:44:21 am »
Also I find in logs long queries for load each avatar (0.2 to 1 sec) and they are not cached. Queries to load avatar are like this:
/index.php?c=files&a=get_public_file&id=0e14fdce887ecc3141a9e26a9ee8f3cf73cd3368

Murz

  • Full Member
  • ***
  • Posts: 147
    • View Profile
Re: Speeding up FENG?
« Reply #20 on: July 13, 2011, 10:12:17 am »
FengOffice when preparing to render page, every time loads same info (users, project list, modules objects, etc). So, we can load it only once at first time and cache in memory (via apc cache or memcached), and for second queries - don't touch database and get them from cache.
If something changed (for example, project modified) we can drop cached object and on page load script rebuild it.
I think that this must greatly improve response time of index.php script .

And maybe better to use not index.php but separate script for ajax queries, but separate script in which we can remove unnecessary processes and queries?

IGaDI

  • Newbie
  • *
  • Posts: 3
    • View Profile
    • Email
Re: Speeding up FENG?
« Reply #21 on: March 18, 2013, 01:52:43 am »
How to reduce the number of queries to the database, or very slowly began to work fengoffice