Hello, try a 'PRAGMA synchronous=OFF;' before executing your statement.
Bye Tue, Jul 27, 2004 at 10:51:58AM +0200: Daniel Franke wrote: > > Hi everyone, > > is there a way to employ more than one process (or processors) in a single > update statement? > > I'm creating a table by inserting rows from a select statement. Given enough > memory this takes a few hours for small datasets and ages for larger ones. > There's a SMP-system next door, 64 cpu's, 64gb of ram - any chance I can use > them to get my results before retirement? :) -- Guillaume FOUGNIES
