Public bug reported:
Code that retrieve widgets is recursive and return widgets for every
candidate widgets ($aiki->widgets->get_candidate_widgets) which is
stupid becasue right now all widgets need to have the same url (in
display_urls field) so they can be retrieve in one query (like in old
aiki).
The reason becasue this may be a problem is that on OCAL there is over
400 queries and there 100 queries to aiki_widgets table which can slow
down the site, those queries are not expensive but if you're sum them up
you can get few seconds delay.
I optimize this code a bit (every query was executed twice one to get
the id and one to get the row from aiki_widgets table)
** Affects: aikiframework
Importance: High
Assignee: Jakub Jankiewicz (jcubic)
Status: New
** Changed in: aikiframework
Assignee: (unassigned) => Jakub Jankiewicz (jcubic)
** Changed in: aikiframework
Milestone: None => 0.9.1
** Changed in: aikiframework
Importance: Undecided => High
--
You received this bug notification because you are a member of Aiki
Framework Admins, which is subscribed to aikiframework.
https://bugs.launchpad.net/bugs/1006828
Title:
Code that get widgets need to be refactored
Status in Aiki Framework:
New
Bug description:
Code that retrieve widgets is recursive and return widgets for every
candidate widgets ($aiki->widgets->get_candidate_widgets) which is
stupid becasue right now all widgets need to have the same url (in
display_urls field) so they can be retrieve in one query (like in old
aiki).
The reason becasue this may be a problem is that on OCAL there is over
400 queries and there 100 queries to aiki_widgets table which can slow
down the site, those queries are not expensive but if you're sum them
up you can get few seconds delay.
I optimize this code a bit (every query was executed twice one to get
the id and one to get the row from aiki_widgets table)
To manage notifications about this bug go to:
https://bugs.launchpad.net/aikiframework/+bug/1006828/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
