[EMAIL PROTECTED] wrote:
I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for this operation?.
Make sure to perform all these insertions in a single transaction: issue a BEGIN statement at the beginning of the batch, and END at the end. Otherwise every insert statement is in its own transaction and has to be independently committed to disk.
How i can insert multiples rows in one INSERT statment??
Only if you already have these rows in some SQLite table. Then you can use INSERT...SELECT form of insert statement. Brand new data has to be inserted one row at a time.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
