Forums / Developer / fetch all users / performance

fetch all users / performance

Author Message

Gernot Rief

Tuesday 09 December 2003 4:33:59 am

hi!

i use the following code:
<select name="{$attribute_base}_ml_goto_{$attribute.id}[]" multiple size="25">

{section loop=fetch( content, list, hash( parent_node_id, 5,depth, 2, class_filter_type, "exclude", class_filter_array, array(3) ))}

<option value="{$:item.contentobject_id}"
{section show=and($attribute.content.uids|contains($:item.contentobject_id),is_array($attribute.content.uids))}selected="selected"{/section}
>{$:item.name|wash} ({$:item.data_map.user_account.content.email})

</option>

{/section}

</select>

= fetch all users into a selectbox and mark the users in $attribute.content.uids (=array of contentobject_ids) as selected.

the code works, but for 450 users it takes about 90 sec (!) to display the page (90% in template)

has anyone any idea how to speed this up?

thx, gernot

Sascha Frinken

Tuesday 09 December 2003 11:05:15 am

450 items (users) are too much for an option list.

You should consider creating a browse page, with a seach function and not more than 50 users per page. After choosing the user(s) from there you return back to where you need it.

You could also write an template operator that fetches the user info directly from the database which will speed things up.

hth

Sascha

Gernot Rief

Tuesday 09 December 2003 11:41:39 pm

hi!

thx for the answer.

writing an operator fixed my prob

gernot

Marco Zinn

Wednesday 10 December 2003 12:41:29 pm

Hi,
do you mind sharing the operator?
I have 7000 users and about 5000 are in one group.
Until now, i don't have to select users in a template dropdown, but it's just a matter of time.

BTW: Doesn't the workflow system (approval) use dropdown-list for users? Or does this use user groups?

Marco
http://www.hyperroad-design.com

eZ debug

Timing: Jan 18 2025 11:03:32
Script start
Timing: Jan 18 2025 11:03:32
Module start 'content'
Timing: Jan 18 2025 11:03:33
Module end 'content'
Timing: Jan 18 2025 11:03:33
Script end

Main resources:

Total runtime1.4479 sec
Peak memory usage4,096.0000 KB
Database Queries199

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0102 588.8281180.8359
Module start 'content' 0.01021.3019 769.6641581.2266
Module end 'content' 1.31210.1357 1,350.8906333.3750
Script end 1.4478  1,684.2656 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00450.3079210.0002
Check MTime0.00190.1338210.0001
Mysql Total
Database connection0.00430.293910.0043
Mysqli_queries1.367394.43131990.0069
Looping result0.00200.14071970.0000
Template Total1.413297.620.7066
Template load0.00220.149220.0011
Template processing1.411197.454920.7055
Template load and register function0.00020.012810.0002
states
state_id_array0.00100.068510.0010
state_identifier_array0.00230.159120.0012
Override
Cache load0.00190.1279350.0001
Sytem overhead
Fetch class attribute can translate value0.00180.124940.0005
Fetch class attribute name0.00110.072850.0002
XML
Image XML parsing0.00100.071840.0003
class_abstraction
Instantiating content class attribute0.00000.000850.0000
General
dbfile0.00460.3150270.0002
String conversion0.00000.000530.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
4content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
6content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
3content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 16
 Number of unique templates used: 6

Time used to render debug report: 0.0004 secs