..for a "unit test"   i need a lot of  rows in my database, so i simulate.

My problem, using  Win2k,R.1.7.0, 256RAM is that i'm getting memory-erros go about the  1000.000 border , but
i need bigger test data. Ok is approriate buy more RAM, but is there a possibilty simulate a lot of single rows, one after
another and between this 2 steps -> Add th row to database and delete them for memory-recover from R ?

Many thanks,Christian

In example:
Nachname     <- round(runif(2000000,1,1000000000))
Vorname      <- round(runif(2000000,1,1000000000))
PLZ          <- round(runif(2000000,10000,14000))
VermittlungskriteriumA   <- round(runif(2000000,1,2))
VermittlungskriteriumB   <- round(runif(200000,1,5))
klient0 <- cbind(Nachname,Vorname,PLZ,VermittlungskriteriumA,)
klient <- as.data.frame(klient0)
rm(klient0)
klient$VermittlungskriteriumA <- as.factor(klient$VermittlungskriteriumA)
levels(klient$VermittlungskriteriumA) <- c("MANN","FRAU")
klient$VermittlungskriteriumB <- as.factor(klient$VermittlungskriteriumB)
levels(klient$VermittlungskriteriumB) <- c("<3Monate","<6Monate","<12Monate","<18Monate","=>24Monate",)

library(RODBC)
channel <- odbcConnect("dsn","root","pass")
sqlSave(channel,klient)

....and more tables 

	[[alternate HTML version deleted]]


