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