Tag Info

New answers tagged

0

Some bulk data loading tips from mysql document is possible useful. https://dev.mysql.com/doc/refman/5.6/en/optimizing-innodb-bulk-data-loading.html You can increase insert speed by some ways: - turn off autocommit - turn off unique check - turn off foreign check Hope this help !


1

Another possibility: Encode the values with Base64. Concatenate the values into a comma-separated string. Pass the resulting string. Split the string in the stored procedure. Decode the strings using Base64. Base64 encodes no comma in its default character set and either is or appears to be supported by: Oracle SQL Server Sysbase PostgreSQL MySQL ...


2

Pass the values as XML (in a VARCHAR). The following database all support shredding XML from the query language: Postgres MySQL SQL Server Oracle DB2 UDM Obviously, not every obscure database on the planet supports it. But the ones above are realistically the only ones you need to care about to hit 99.9% of the database market.



Top 50 recent answers are included