surround them in a transaction. BEGIN INSERT... INSERT... COMMIT
On 11/2/06, [EMAIL PROTECTED] <[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?. In other case... How i can insert multiples rows in one INSERT statment?? Thanks. ------------------------------------------------ CiberCorreos(r) Acercando las Nuevas Tecnologías a la población. http://www.ciudadano.cu/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
-- Cory Nelson http://www.int64.org