supabase-py icon indicating copy to clipboard operation
supabase-py copied to clipboard

Bulk inserts

Open yan-hic opened this issue 2 years ago • 0 comments

What is the limit or ideal number of rows for a single insert() method call ? Is the SDK using page size and flush in batches like other CRUD libraries ?

I am not sure the supabase SDK is optimized to load large data but either way, a word of caution in the documentation would help e.g. use psycopg or copy_from over a threshold

yan-hic avatar Mar 10 '23 01:03 yan-hic