On Tue, 2006-01-24 at 11:33 +0100, FERREIRA, William (VALTECH) wrote:
> the times are always the same, except with the centrino for which it takes 1
> min.
Oracle or PostgreSQL? i.e. is the Centrino faster or slower?
> -Postgresql plan :
Please post the EXPLAIN ANALYZE.
Thanks,
--
Simon Ri
"FERREIRA, William (VALTECH)" <[EMAIL PROTECTED]> writes:
> here is the EXPLAIN ANALYSE of my query :
That's not an EXPLAIN ANALYZE ... that's an EXPLAIN VERBOSE, which is
hardly ever of any use for performance issues.
regards, tom lane
---(end of
26..0.034 rows=1 loops=1)
Index Cond: ((doc_id = $0) AND (ele_id = $1) AND
(evolution <= 0) AND (child_id = $2))
Filter: (child_class = $3)
Total runtime: 0.483 ms
-Message d'origine-
De : [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] la part
hi,
i have a database storing XML documents.
The main table contains the nodes of the document, the other tables contain
data for each node (depending on the node's type : ELE, Text, PI, ...)
My test document has 115000 nodes.
the export of the document(extracting all informations from database
