On Friday 17 August 2007 11:14:53 Jens Ansorg wrote: > Hi Jens,
I tried again and created a simple query in the SQL view: > > SELECT l.id, l.airwayId, w.ident FROM AirwayLegs AS l, Airways AS w > WHERE l.airwayid = w.id AND l.id < 10 > > I did not check the result, I just hit the "save" button. > > OOO Base starts consuming 100% CPU (fortunately only one core of my dual > core system). I left it running and checked back later: It got finally > saved. As per taskmanager, the CPU Time for the soffice.bin process is > about 12 minutes > Have you tried limiting the number of responses with the LIMIT command instead of the second where condition to see at which point the join causes performance to drop off ? Alex --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
