On Sun, 2005-07-24 at 17:57 +0900, Tatsuo Ishii wrote: > It seems current CE implementation ignores UPDATE, DELETE quries. Is > this an intended limitation?
Yes, it does not currently optimise the execution of UPDATE/DELETE against a parent table. This is not an intended long-term limitation and I hope to fix this also. The code for this is actually in a different place to the code for SELECT, so I need to do extra work to fix that. My priority for CE was to provide for the most common rolling window use cases on very large databases, so in those cases UPDATEs or DELETEs against large tables are actually fairly suicidal statements; that meant that feature had a lower implementation priority....but as I say, I will get to that. Best Regards, Simon Riggs ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend