Multiple filters on search, good design suggestions?

Next topic

Author	Message
Håvard Bell	Thursday 18 November 2004 1:56:41 pm Hi, We are building a web site that has a number of courses. Each course is held at a certain place, is of a certain type, and is thought by a certain person. We want to list all courses at this place, or all courses of this type, or all courses thought by this person. For example: Course A is held in Oslo, thought by Adam, and is of type Advanced. Course B is held in New York, thought by Adam and is of type Beginner. Course A and Course B will show up on the list of courses thought by Adam. Only course A will show up on the list of courses held in Oslo, and so fourth. Initially we have designed the object model such that each course has attributes that are object relations to place object, person object or coursetype object. The problem with this is that in one fetch statement, we cannot filter based on some values in an object related to through a related object attribute. A solution is to fetch all courses, then we filter out what we need, manually, through a loop in the template. This feels, at least now, problematic with regards to performance if the course list is large. Does anybody have any good suggestions on how we can solve this in the most efficient, and "eZ Publish like" way? Thanks, ~ Hav.

Author

Message

Thursday 18 November 2004 1:56:41 pm

Hi,

We are building a web site that has a number of courses. Each course is held at a certain place, is of a certain type, and is thought by a certain person. We want to list all courses at this place, or all courses of this type, or all courses thought by this person.

For example: Course A is held in Oslo, thought by Adam, and is of type Advanced. Course B is held in New York, thought by Adam and is of type Beginner. Course A and Course B will show up on the list of courses thought by Adam. Only course A will show up on the list of courses held in Oslo, and so fourth.

Initially we have designed the object model such that each course has attributes that are object relations to place object, person object or coursetype object. The problem with this is that in one fetch statement, we cannot filter based on some values in an object related to through a related object attribute.

A solution is to fetch all courses, then we filter out what we need, manually, through a loop in the template. This feels, at least now, problematic with regards to performance if the course list is large.

Does anybody have any good suggestions on how we can solve this in the most efficient, and "eZ Publish like" way?

Thanks,

~ Hav.

eZ debug

Timing:	Jan 19 2025 04:37:12
Script start
Timing:	Jan 19 2025 04:37:12
Module start 'layout'
Timing:	Jan 19 2025 04:37:12
Module start 'content'
Timing:	Jan 19 2025 04:37:14
Module end 'content'
Timing:	Jan 19 2025 04:37:14
Script end

Main resources:

Total runtime	1.5836 sec
Peak memory usage	4,096.0000 KB
Database Queries	46

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0078	589.3828	152.6406
Module start 'layout'	0.0078	0.0056	742.0234	39.4766
Module start 'content'	0.0135	1.5685	781.5000	400.3672
Module end 'content'	1.5820	0.0016	1,181.8672	8.1250
Script end	1.5836		1,189.9922

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.2234	16	0.0002
Check MTime	0.0014	0.0890	16	0.0001
Mysql Total
Database connection	0.0009	0.0565	1	0.0009
Mysqli_queries	1.5436	97.4696	46	0.0336
Looping result	0.0004	0.0280	44	0.0000
Template Total	1.5470	97.7	2	0.7735
Template load	0.0022	0.1420	2	0.0011
Template processing	1.5447	97.5423	2	0.7724
Template load and register function	0.0003	0.0161	1	0.0003
states
state_id_array	0.0010	0.0609	1	0.0010
state_identifier_array	0.0010	0.0652	2	0.0005
Override
Cache load	0.0018	0.1139	11	0.0002
Sytem overhead
Fetch class attribute can translate value	0.0007	0.0442	1	0.0007
Fetch class attribute name	0.0005	0.0307	1	0.0005
XML
Image XML parsing	0.0001	0.0064	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0002	1	0.0000
General
dbfile	0.0007	0.0455	10	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
1	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
1	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 4 Number of unique templates used: 4

Time used to render debug report: 0.0001 secs