remapping the directory structure

Next topic

Author	Message
cfa cfa	Wednesday 30 July 2003 9:47:39 pm i am currently working on a product-index for a multi-language site (where every language got its own siteaccess). the products and productgroups are plenty (more than 500) are organized in the following (simpliefied) directory structure: productgroup - product now i want to add geographical information (country and province) to this directory structure (or the product-class object) where this geographical information would be accessed in two ways: productgroup - product - country - province (the normal way) country - province - productgroup - product (the re-mapped way) the user should experience the COUNTRY and STATE as part of the directory structure (like it is done on YAHOO) and just click himself thru to the desired PRODUCT from top-to-bottom or the other way round. i tried out the following ways of implementation: DIRECTORY STRUCTURE - just make two of them! some countries have a lot of provinces, and there are many countries on this earth! ENUM-FIELD implementation of country and province but failed to create a good relation between COUNTRY and PROVINCE, ENUM-fields can t get translated into other languages either. RELATED OBJECT to a country and its province (and just create te countries and provinces needed during input). this worked good with multi-languages! COUNTRY CLASS object. there was one posted, but only in english... thanks!

Author

Message

Wednesday 30 July 2003 9:47:39 pm

i am currently working on a product-index for a multi-language site (where every language got its own siteaccess).

the products and productgroups are plenty (more than 500) are organized in the following (simpliefied) directory structure:

productgroup - product

now i want to add geographical information (country and province) to this directory structure (or the product-class object) where this geographical information would be accessed in two ways:

productgroup - product - country - province (the normal way)
country - province - productgroup - product (the re-mapped way)

the user should experience the COUNTRY and STATE as part of the directory structure (like it is done on YAHOO) and just click himself thru to the desired PRODUCT from top-to-bottom or the other way round.

i tried out the following ways of implementation:

DIRECTORY STRUCTURE - just make two of them! some countries have a lot of provinces, and there are many countries on this earth!

ENUM-FIELD implementation of country and province but failed to create a good relation between COUNTRY and PROVINCE, ENUM-fields can t get translated into other languages either.

RELATED OBJECT to a country and its province (and just create te countries and provinces needed during input). this worked good with multi-languages!

COUNTRY CLASS object. there was one posted, but only in english...

thanks!

eZ debug

Timing:	Jan 18 2025 21:09:06
Script start
Timing:	Jan 18 2025 21:09:06
Module start 'layout'
Timing:	Jan 18 2025 21:09:06
Module start 'content'
Timing:	Jan 18 2025 21:09:07
Module end 'content'
Timing:	Jan 18 2025 21:09:07
Script end

Main resources:

Total runtime	1.5078 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.0082	592.1094	152.6406
Module start 'layout'	0.0082	0.0033	744.7500	39.4766
Module start 'content'	0.0115	1.4946	784.2266	405.8359
Module end 'content'	1.5061	0.0016	1,190.0625	8.1406
Script end	1.5078		1,198.2031

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0042	0.2792	16	0.0003
Check MTime	0.0017	0.1108	16	0.0001
Mysql Total
Database connection	0.0007	0.0460	1	0.0007
Mysqli_queries	1.4628	97.0118	46	0.0318
Looping result	0.0006	0.0422	44	0.0000
Template Total	1.4644	97.1	2	0.7322
Template load	0.0023	0.1545	2	0.0012
Template processing	1.4621	96.9649	2	0.7310
Template load and register function	0.0002	0.0158	1	0.0002
states
state_id_array	0.0016	0.1073	1	0.0016
state_identifier_array	0.0023	0.1516	2	0.0011
Override
Cache load	0.0019	0.1256	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0009	0.0607	1	0.0009
Fetch class attribute name	0.0008	0.0547	1	0.0008
XML
Image XML parsing	0.0001	0.0075	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0003	1	0.0000
General
dbfile	0.0017	0.1103	10	0.0002
String conversion	0.0000	0.0005	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
2	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 6 Number of unique templates used: 5

Time used to render debug report: 0.0001 secs