R help - Jun 2011 - “foreach” loop : Using all cores in R (especially if we are sending sql queries inside foreach loop)

Hi, I intend to use "foreach" to uitlize all the cores in my CPU. The
catch
is i need to send a sql query inside the loop. The script is working fine
with normal 'for' loop, but it is giving following error when i change
it to
'foreach'. The error is :

select: Interrupted system call

select: Interrupted system call

select: Interrupted system call

Error in { : task 1 failed - "expired MySQLConnection"

The code i used is :

library(foreach)

library(doMC)

library(RMySQL)

library(multicore)

registerDoMC(cores=6)

m <- dbDriver("MySQL", max.con = 100)

con <- dbConnect(m, user="***", password = "****", host =
"*.*.***
",dbname="dbname")

list<-dbListTables(con)

foreach(i = 1:(length(list))*%dopar%* {

query<-paste("SELECT * FROM ",list[i]," WHERE CLOSE BETWEEN 1
AND
100",sep="")

t<-dbGetQuery(con,query)

}

Though 'foreach' is working fine in my system for all other purposes, it
is
giving error only in case of sql queries. Is there a way to send sql queries
inside 'foreach' loop?

Thanks for your time.

	[[alternative HTML version deleted]]