> From: Denis Samson > Sent: Wednesday, 16 June 2010 12:34 > > I'm having lots of fun porting an old, huge J application still > running on J5.03 (!) and using a SQLite database. The goal is 1- to > get it to use MySQL 5.x instead through an ODBC connection, then 2- > move the whole thing to J6.02... ... > > 3- Does anyone ever bulkinserts into MySQL or anywhere else (and if so, > how?)
As a SQLite user you are probably familiar with the data/sqlite addon in JAL, but in case you're not it has routines for doing bulk inserts. http://www.jsoftware.com/jwiki/Addons/data/sqlite http://www.jsoftware.com/svn/addons/trunk/data/sqlite/test/bench.ijs It doesn't use an ODBC connection though, so I'm not sure how much it will help you with transferring your data to MySQL. ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
