Thank You! Vikas
On Nov 21, 2016, at 12:09 PM, Richard Hipp <[email protected]> wrote: > 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 _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
