Skip to content

Inserting Multiple Records Into a Table

World Wide Web Server edited this page Jul 4, 2012 · 19 revisions

Category:Library::Database

Inserting multiple records into a database table at once is something that is not currently handled by CodeIgniter's database methods.

In the event that many records need to be inserted into a table, a significant performance increase can be gained by executing a large query with multiple rows being inserted instead inserting rows in individual queries.

This article will document an extension of the CodeIgniter model with methods that allow for efficient insertion of data upwards of 1,000 rows.

-- Stub --

Clone this wiki locally