Feng Forum

Support => Older versions => Topic started by: artvolk on July 29, 2009, 04:11:36 pm

Title: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on July 29, 2009, 04:11:36 pm
Good day!

I've upgraded 1.4.2 to 1.5 by overwriting files and running /files/upgrade using instructions in readme.txt

The Overview page loads very slow (with high load on mysql) and show only work 'null' at the end if any the following  widgets on the dashboard are enabled:

- Show pending tasks widget:
- Show late tasks and milestones widget:
- Show 'Tasks in progress' widget:

I've set debug to true in config, but still got no detailed error message.

Thanks in advance for any help!
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview"
Post by: artvolk on July 29, 2009, 04:22:03 pm
One more thing -- browsing Tasks also is very slow, I've reverted to 1.4.2 version -- and it works good.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview"
Post by: ignacio on July 30, 2009, 02:44:54 pm
How many tasks do you have system-wide approximately?
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview"
Post by: artvolk on July 30, 2009, 02:59:24 pm
Good day!

Table `og_project_tasks` has 496 records. Please let me know if you need any other information.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ignacio on July 30, 2009, 03:17:30 pm
Ok, it's not too many tasks, so that is not the problem. Are you using InnoDB or MyISAM as your database engine?
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on July 30, 2009, 04:46:55 pm
I use MyISAM and this seems to be 1.5 related, because 1.4.2 with the same (but not upgraded DB) works good, by the way, I'm not the only one :), here are topics with the same problems

OG 1.5 final act very slow
http://forums.opengoo.org/index.php?topic=2313.0

1.5 final - one user having problem with OG while others don't
http://forums.opengoo.org/index.php?topic=2288.0
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on August 03, 2009, 04:34:10 am
Does anybody have the following problems?

Can I help in anyway by gathering more detailed information?
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ignacio on August 03, 2009, 11:54:17 am
I will try to check out an installation with MyISAM . You know we don't recommend using MyISAM. Originally it was due to lack of transactions. Now it seems that it will have some performance issues too. Of course, if we can find a solution we will fix it.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on August 03, 2009, 12:06:23 pm
Good day!

MyISAM is considered faster on selects (or at least comparable):
http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/

1.4.2 run smoothly and really fast on my current hardware, does 1.5. have a lot of changes?

I left 1.5 installation with problem on my server to run any tests to help you troubleshoot.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ignacio on August 03, 2009, 03:32:36 pm
There's two important changes that I can think of that could have messed MyISAM performance:

One is that tasks, milestones, events and weblinks now use another table to associate them to workspaces. Previously this association was done with a column containing the workspace's id. Now it's a table that associates object id to workspace id. It's the same table that was previously being used for Notes, Documents, Email and Companies, so if you have been using

The other is that when filtering workspaces previously we were giving all of the workspace IDs directly in the query and now we are giving a subquery instead of the IDs. It turned out to be much faster in InnoDB when there are lots of workspaces, because otherwise to obtain the IDs you would have to iterate through all workspaces in PHP.

About MyISAM being faster, I thought that too before, but lately I have been searching the web and found several websites with benchmarks showing that InnoDB is faster. On several tests I performed on OpenGoo, InnoDB turned out to be faster, except on some queries like SELECT count(*) FROM table on which MyISAM was faster.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on August 04, 2009, 05:07:51 am
Thank you for the detailed description. I will try to upgrade once more and move database to InnoDB engine. I will let you know if it helps.

Thanks again!
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: artvolk on August 15, 2009, 04:16:10 pm
Good day!

Have you got a chance to fix the issues in 1.5.2?

Thanks!
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ravex on August 17, 2009, 07:03:42 am
Its strange. but i found problem but don't understand how fix it.

1. So if we create Subtask in Task. and name it in Cyrrilic (Russian) more than 22 symbols for example:
Quote
Документирование тест
and return to Overview tab. we get a "NULL message"

2. But if  name  of subtask in English for example same translated or transliterated 22 symbol message
Quote
Dokumentirovanie test
and return to Overview tab. we get our Overview tab with Widgets without any errors.

and very strange fact is:

3. But if  name  in English + Cyrrilic (Russian) for example same translated or transliterated 22 symbol message + original  Russian letters
Quote
Dokumentirovanie тест, очень много тестов
and return to Overview tab. we also get a our Overview Widgets without any errors.

what  is type of problem? how can fix this?
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ravex on August 17, 2009, 07:28:15 am
Here another example
words like
Quote
Документирование дополнительно
Документирование_дополнительно
Документирование+дополнительно
Документирование-дополнительно
null return

but same english
Quote
Dokumentirovanie dopolnitel'no
Dokumentirovanie_dopolnitel'no
Dokumentirovanie+dopolnitelno
Dokumentirovanie-dopolnitelno
return Widgets without "null"

and if remove any "'space'. '-'. '+'. '_' " symbols in Cyrrilic version and merge this two words into one big word
Overview tab also return Widgets without "null"
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: milchbazi on August 17, 2009, 01:50:18 pm
When any tab is selected (like email) and you press on the "all" workspace, you will always get an overview shown while the activated tab remains email.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: ignacio on August 24, 2009, 11:28:43 am
Hi ravex,

Please try changing "substr" for "utf8_substr" on lines 80 and 186 of 'application/views/dashboard/widget_late_tasks.php' and on line 34 of 'application/views/dashboard/widget_pending_tasks.php'.

Thanks.
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: mobang on August 27, 2009, 09:20:34 am
Hi,

stumbled over the same problem.

The Overview of the workspace that was open during the upgrade from 1.4.2 to 1.5.2 showed me a "NULL" message. After changing the substr this overview worked again. All others were working before.

So for me the problem is solved.

Thanks
Ralf
Title: Re: upgrade from 1.4.2 to 1.5 -- problem with "overview" + perfomance problems
Post by: frankuser on August 31, 2009, 04:01:11 pm
Hi,

this also worked for me (1.5.2). Thanks.

- Francesco