A cure for laziness

Next topic

Author	Message
Tristan Koen	Wednesday 20 August 2003 12:42:51 pm I have modified my user class, adding some new fields. One of the new fields is "country" and has an 'enum' datatype. I have a list of countries (there are a couple of hundred of them) that need to be loaded into the enum. This could end up taking a very long time. Can anyone suggest a more efficient way to load them? INserting directly into the database would be find if somebody could give me the table/row details required for this operation. Thanks

Author

Message

Wednesday 20 August 2003 12:42:51 pm

I have modified my user class, adding some new fields. One of the new fields is "country" and has an 'enum' datatype.

I have a list of countries (there are a couple of hundred of them) that need to be loaded into the enum. This could end up taking a very long time.

Can anyone suggest a more efficient way to load them? INserting directly into the database would be find if somebody could give me the table/row details required for this operation.

Thanks

eZ debug

Timing:	Jan 31 2025 06:41:11
Script start
Timing:	Jan 31 2025 06:41:11
Module start 'layout'
Timing:	Jan 31 2025 06:41:11
Module start 'content'
Timing:	Jan 31 2025 06:41:12
Module end 'content'
Timing:	Jan 31 2025 06:41:12
Script end

Main resources:

Total runtime	1.1742 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.0060	590.0234	151.2109
Module start 'layout'	0.0060	0.0033	741.2344	36.6328
Module start 'content'	0.0093	1.1640	777.8672	821.6719
Module end 'content'	1.1733	0.0009	1,599.5391	7.8750
Script end	1.1742		1,607.4141

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0034	0.2901	16	0.0002
Check MTime	0.0014	0.1152	16	0.0001
Mysql Total
Database connection	0.0009	0.0799	1	0.0009
Mysqli_queries	1.1351	96.6664	46	0.0247
Looping result	0.0004	0.0355	44	0.0000
Template Total	1.1335	96.5	2	0.5668
Template load	0.0028	0.2363	2	0.0014
Template processing	1.1307	96.2965	2	0.5654
Template load and register function	0.0013	0.1125	1	0.0013
states
state_id_array	0.0022	0.1840	1	0.0022
state_identifier_array	0.0022	0.1846	2	0.0011
Override
Cache load	0.0023	0.1921	7	0.0003
Sytem overhead
Fetch class attribute can translate value	0.0004	0.0372	1	0.0004
Fetch class attribute name	0.0016	0.1349	1	0.0016
XML
Image XML parsing	0.0001	0.0102	1	0.0001
class_abstraction
Instantiating content class attribute	0.0000	0.0004	1	0.0000
General
dbfile	0.0007	0.0626	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