On 11/21/16, Vikas Aditya <vikas.adi...@quikfynd.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
