I do not think this is a bug. Delete command is alway slower than truncate even in Oracle because delete occured record by record during a transaction and has to be commited. Truncate dosn't need any commit and occurs on the whole table so it is faster.
Regards ---------------------------------------------------------------- Olivier Gayte Veremes http://www.veremes.com/ 42 av. des Jardins 66240 St Esteve France tél +33 (0)4-68-38-65-27 mobile +33 (0)6-60-49-83-81 fax +33 (0)4-26-68-98-35 [EMAIL PROTECTED] ---------------------------------------------------------------- ----- Original Message ----- From: ""Prévost, Jean-Marc"" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Friday, July 08, 2005 7:26 PM Subject: [fme] Deleting feature in ArcSDE. > Hi, > > Our mapping production process includes many steps and one of them needs > to > delete all features of an entire working area. To do that we use an > ArcObject program that let you define the working area and feature classes > that need to be deleted. We tried the same thing with FME (ArcSDE reader) > using ArcSDEQuerier. We give it a polygon delimiting the area, we choose > features classes, we set an attribute constraint and then, at the end, we > set the transformer on DELETE instead of QUERY. It works but its waayyy > slower then the ArcObject solution. It's the first time, in our > experience, > that FME is slower then an ArcObject program. Is it because we don't use > FME > the right way? Is it because ArcSDEQuerier has a bug? > > Thanks in advance! > > Jean-Marc Prévost > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via > our Professional Services team. Visit www.safe.com/services for details. > Yahoo! Groups Links > > > > > > > Get the maximum benefit from your FME, FME Objects, or SpatialDirect via our Professional Services team. Visit www.safe.com/services for details. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
