Storing relations in SQL base

Next topic

Author	Message
Vladimir Shiray	Thursday 11 August 2005 2:33:58 am I has found that our production EZ base contains duplicate records in the 'ezcontentobject_link' table. I say about combination of three fields: from_contentobject_id from_contentobject_version to_contentobject_id Has it a sense? Can it be a reson for any problem? Is it possible to create UNIQUE key based on these fields? I removed duplicates in test copy with direct SQL query: DELETE FROM ezcontentobject_link WHERE id NOT IN ( SELECT max(id) FROM ezcontentobject_link GROUP BY from_contentobject_id, from_contentobject_version, to_contentobject_id ); Can it lead to a problem ?

Author

Message

Thursday 11 August 2005 2:33:58 am

I has found that our production EZ base
contains duplicate records in the
'ezcontentobject_link' table.
I say about combination of three fields:
from_contentobject_id
from_contentobject_version
to_contentobject_id

Has it a sense?
Can it be a reson for any problem?
Is it possible to create UNIQUE key
based on these fields?

I removed duplicates in test copy with
direct SQL query:

DELETE FROM ezcontentobject_link
WHERE id NOT IN (
SELECT max(id)
FROM ezcontentobject_link
GROUP BY from_contentobject_id, from_contentobject_version, to_contentobject_id
);

Can it lead to a problem ?

eZ debug

Timing:	Jan 31 2025 08:06:16
Script start
Timing:	Jan 31 2025 08:06:16
Module start 'layout'
Timing:	Jan 31 2025 08:06:16
Module start 'content'
Timing:	Jan 31 2025 08:06:16
Module end 'content'
Timing:	Jan 31 2025 08:06:16
Script end

Main resources:

Total runtime	0.0151 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0043	588.1328	151.2109
Module start 'layout'	0.0044	0.0020	739.3438	36.6484
Module start 'content'	0.0064	0.0071	775.9922	86.0313
Module end 'content'	0.0135	0.0016	862.0234	29.9922
Script end	0.0151		892.0156

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0020	13.3718	14	0.0001
Check MTime	0.0009	6.2099	14	0.0001
Mysql Total
Database connection	0.0007	4.6007	1	0.0007
Mysqli_queries	0.0022	14.5618	3	0.0007
Looping result	0.0000	0.0725	1	0.0000
Template Total	0.0012	7.9	1	0.0012
Template load	0.0009	5.7907	1	0.0009
Template processing	0.0003	2.1230	1	0.0003
Override
Cache load	0.0005	3.4564	1	0.0005
General
dbfile	0.0034	22.7402	8	0.0004
String conversion	0.0000	0.0331	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