Posted by Robert G Laurin on October 19, 2015 at 10:49:12:
In Reply to: Re: ODBC posted by Yves Duperron on October 19, 2015 at 07:37:00:
Another method I've used for years: Generate dot-sql files with all the updates and have a cron job monitor the Comet folder for any new sql and process them using command line options.
Works extremely well with Linux.
I used this exactly because the tiny-weeny ODBC write buffer (254 bytes minus overhead) is a pain.
I limited my dot-sql files to 1,000,000 records with a new insert/update query every 1,000 records.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.