interfaces for loading with maximum speed.
For Oracle the Direct Path Load interface is used.
For SQL Server loading is based on the memory-based bulk-copy operations using the IRowsetFastLoad interface. Data loading is performed without transactions.
For PostgreSQL data are loaded using the COPY command.
For MySQL, InterBase, and Firebird loading uses INSERT SQL statements. In this case several rows are combined in one statement if possible. In Firebird 2.0 and higher INSERT statements are combined in one EXECUTE BLOCK statement.
Есть что подобное на FireDAC?
Ecть array dml. И tfddatamove, но им я не пользовался
И не удивительно. Да быстро, но ограничения серьезные. Для Oracle, использую Array Insert+Append.
Обсуждают сегодня