--- Manzoor Ilahi Tamimy <[EMAIL PROTECTED]> wrote: > DISK MODE > 3000 000 INSERTS 31 Seconds 96774 INSERTS / Sec > "SELECT * from t" 5 Seconds. > > MEMORY MODE > 3000 000 INSERTS 53 Seconds 56604 INSERTS / Sec > "SELECT * from t" 5 Seconds. > > Can I reduce the TIME of DISK mode or this is the limit. > WHY the Time in MEMORY mode is higher than DISK in case of INSERTION.
Are you running a version of SQLite older than 3.3.6? http://www.sqlite.org/cvstrac/tktview?tn=1790 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com