Forums / General / Object relations and big number of records

Object relations and big number of records

Author Message

Carlos Revillo

Sunday 01 June 2008 3:30:19 am

Hi.

I have a class, let's call it A, with about 15 attributes. One of this attributes is a relation of objects of another class, call it B. for this other class (B) i have about 40.000 records.

The problem begins when i have to edit an object of A class.
I mean, if for this attribute i choose "multiselect options". it takes too long to fill all the 40.000 records in the multiselect option.

If i choose select by browsing, it's very tedious for the editor to find the right object in about 800 pages of 50 records each one...

Do you know how can i filter the objects to relate? For more information, i can say that A class is a class with information about films, and B class is a class with actors information. So, what i want is to relate films with actors.

I wonder if is there any way to let the editors "search" for actors, and then choose the right ones in that search results. so, they won't need to search for actors page by page...

Any help would be appreciated. Thank you.

eZ debug

Timing: Jan 18 2025 23:16:54
Script start
Timing: Jan 18 2025 23:16:54
Module start 'content'
Timing: Jan 18 2025 23:16:55
Module end 'content'
Timing: Jan 18 2025 23:16:55
Script end

Main resources:

Total runtime1.0627 sec
Peak memory usage4,096.0000 KB
Database Queries183

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0055 587.8359180.8203
Module start 'content' 0.00550.9392 768.6563407.5313
Module end 'content' 0.94470.1179 1,176.1875329.7891
Script end 1.0626  1,505.9766 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00400.3787210.0002
Check MTime0.00140.1321210.0001
Mysql Total
Database connection0.00080.078410.0008
Mysqli_queries1.004094.48131830.0055
Looping result0.00160.14891810.0000
Template Total1.034197.320.5170
Template load0.00190.177920.0009
Template processing1.032297.129120.5161
Template load and register function0.00010.013810.0001
states
state_id_array0.00090.082010.0009
state_identifier_array0.00140.127320.0007
Override
Cache load0.00150.1452110.0001
Sytem overhead
Fetch class attribute can translate value0.00160.147620.0008
Fetch class attribute name0.00090.085110.0009
XML
Image XML parsing0.00050.045720.0002
class_abstraction
Instantiating content class attribute0.00000.000510.0000
General
dbfile0.00630.5949210.0003
String conversion0.00000.000430.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
1content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
2content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
1content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 6
 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs