On 11/21/16, Vikas Aditya <[email protected]> wrote: > > Currently we are using: > > sql = "INSERT INTO {} SELECT * FROM {}".format(totable, fromtable) > cur.execute(sql) > > So, a single line statement can copy from old to new. But will this work > fine even if I have 100s of thousands of records in old table? Or will this > load pretty much entire data into memory and then copy to new? \ The case above is highly optimized and should work fine for you, with minimal memory usage.
-- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
