[sqlite] Segmentation fault on database with 2.2 Gb

well... I would be very glad for some help. At the bottom you find the strace output. Thanks a lot Hubertus execve("/usr/bin/sqlite3", ["sqlite3", "data.db", "1"], [/* 34 vars */]) = 0 brk(0) = 0x805 access("/e

Re: [sqlite] Strange performance behavior

e done by sqlite? Thank Hubertus - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Strange performance behavior

t;' % col, campId query <- paste('SELECT "34" AS "N2O_TDL", "29" AS "O3"', 'FROM data where campId="polstar97"') rs <- dbSendQuery(con, statement = query) How is this done correctly? Thanks a lot Hubertus - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Strange performance behavior

sec. Why is that so and what can be done? I can live with 3 sec of response but not up to one minute and the database is still not complete. Would pytables with hdf5 be an alternative? Knowing that this is probably not the right place to ask... Tips, suggestions, recommendation are gratefuly appreciated! Thanks in advance Hubertus - To unsubscribe, send email to [EMAIL PROTECTED] -