Re: ODBC

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]

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.


Follow Ups:


Post a Followup

Name:
E-Mail:

Subject:

What is the name of the main Signature System's Product?  

Comments:

Optional Link URL:
Link Title:
Optional Image URL:

You may attach up to 5 files to your followup (see below):





Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.

[ Follow Ups ] [ Post Followup ] [ Signature.net Forum ]