urgent help needed: mass user prune

Next topic

Author	Message
Dimitar Christoff	Monday 06 November 2006 6:15:57 am Hey there... i go a system that got populated with almost 100k users (to test load/concept) that now needs to get them dropped. the problem is that deleting them 1 by 1 via the eZContentObjectTreeNode::removeSubTrees seems to be taking toooooo long, I have an ETa of 24 hrs remaining at a rate of a little over 1 per second.... can anybody think of a quick and dirty way of deleting all objects and attributes via mysql, for example, there are no related objects to these users... otherwise i'd have to wait it out ... thanks VisionWT

Author

Message

Monday 06 November 2006 6:15:57 am

Hey there...

i go a system that got populated with almost 100k users (to test load/concept) that now needs to get them dropped. the problem is that deleting them 1 by 1 via the eZContentObjectTreeNode::removeSubTrees seems to be taking toooooo long, I have an ETa of 24 hrs remaining at a rate of a little over 1 per second....

can anybody think of a quick and dirty way of deleting all objects and attributes via mysql, for example, there are no related objects to these users...

otherwise i'd have to wait it out ... thanks

VisionWT

eZ debug

Timing:	Jan 18 2025 22:23:07
Script start
Timing:	Jan 18 2025 22:23:07
Module start 'layout'
Timing:	Jan 18 2025 22:23:07
Module start 'content'
Timing:	Jan 18 2025 22:23:07
Module end 'content'
Timing:	Jan 18 2025 22:23:07
Script end

Main resources:

Total runtime	0.0195 sec
Peak memory usage	4,096.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0088	589.0469	152.6250
Module start 'layout'	0.0089	0.0047	741.6719	39.4453
Module start 'content'	0.0136	0.0042	781.1172	85.1016
Module end 'content'	0.0177	0.0018	866.2188	30.3047
Script end	0.0195		896.5234

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	16.7912	14	0.0002
Check MTime	0.0015	7.8354	14	0.0001
Mysql Total
Database connection	0.0009	4.7049	1	0.0009
Mysqli_queries	0.0043	21.9342	3	0.0014
Looping result	0.0000	0.0769	1	0.0000
Template Total	0.0014	7.3	1	0.0014
Template load	0.0008	4.3412	1	0.0008
Template processing	0.0006	2.9743	1	0.0006
Override
Cache load	0.0006	2.8669	1	0.0006
General
dbfile	0.0005	2.3396	8	0.0001
String conversion	0.0000	0.0879	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs