Forums / Developer / Most effiecient way to filter

Most effiecient way to filter

Author Message

Brendan Pike

Sunday 27 August 2006 5:51:35 am

I do recall seeing a conversation about this some time ago but couldn't locate it.

I'm using several view_parameters to allow users to filter a fetch of usually around 200 - 300 objects. Like only show objects with a location of node_id, 432 and a ezselect state of 3 etc. My question is what is best method of filtering. Is it with a {section-exclude} within the loop or is there a way to perform the filtering within the fetch itself?

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

Kristof Coomans

Sunday 27 August 2006 11:19:34 am

Hello Brendan

Info on filtering attributes of the selection datatype (single select only):
http://ez.no/community/forum/setup_design/filter_content_passing_values_from_url

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Brendan Pike

Sunday 27 August 2006 8:48:39 pm

Thanks Kristof, that thread was very informative. After reading that thread I realised I am trying to filter a "ebhanced selection" datatype. I was hoping to avoid the complexity of the extended_attribute_filter but its starting to feel that's the only way. Perhaps I shouldn't be reaching for the "enhanced selector" quite so often after all.

Can you give me your opinion on how to filter on:
A. Enhanced Selectors
B. Node locations, (inspect locations and filter out certain nodes)

Achieving this with section-excludes within a loop is relatively easy but I thought it was a slow method since your fetching larger volumes of objects.

Thanks for any tips.

www.dbinformatics.com.au

We are always interested in hearing from experienced eZ PHP programmers and eZ template designers interested in contract work.

Kristof Coomans

Monday 28 August 2006 1:43:36 am

With the enhanced selection datatype, you can just use the identifier of your option as the filter value. Again this only works for a single selection.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

eZ debug

Timing: Jan 18 2025 18:41:16
Script start
Timing: Jan 18 2025 18:41:16
Module start 'content'
Timing: Jan 18 2025 18:41:16
Module end 'content'
Timing: Jan 18 2025 18:41:16
Script end

Main resources:

Total runtime0.1569 sec
Peak memory usage2,048.0000 KB
Database Queries141

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0054 588.8438180.8359
Module start 'content' 0.00540.0047 769.679797.8672
Module end 'content' 0.01010.1468 867.5469526.0234
Script end 0.1569  1,393.5703 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00332.0766200.0002
Check MTime0.00130.8094200.0001
Mysql Total
Database connection0.00060.410310.0006
Mysqli_queries0.114372.81251410.0008
Looping result0.00150.97141390.0000
Template Total0.146593.310.1465
Template load0.00070.441410.0007
Template processing0.145892.879210.1458
Override
Cache load0.00050.315510.0005
Sytem overhead
Fetch class attribute can translate value0.00070.448010.0007
XML
Image XML parsing0.00030.211010.0003
General
dbfile0.00281.8104200.0001
String conversion0.00000.003930.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
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs