Re: Large inserts, chunking and Concat

2004-05-19 Thread John Ling
in my test to about 240MBs. There may still be a problem as the data grows beyond this. John Harald Fuchs wrote: In article <[EMAIL PROTECTED]>, John Ling <[EMAIL PROTECTED]> writes: Hello, realizing that there is a max_allowed_packet setting that limits the size of the insert s

Large inserts, chunking and Concat

2004-05-17 Thread John Ling
Hello, realizing that there is a max_allowed_packet setting that limits the size of the insert statement, is there a way around it by chunking the query? In particular, if the query is to insert a large text or blob, can I simply concatenate smaller pieces of the data in succession using the C

Comparing and writing out BLOBS

2004-03-19 Thread John Ling
I had posted the following code in the plusplus mailing list but it was suggested I post this question in this list instead. I've been writing a test program using the MySQL C API to test the reading and writing of BLOB data in and out of the database. The file I read into the database is a sm

Re: Relationship between libz and libmysqlclient libraries

2004-03-08 Thread John Ling
Paul DuBois wrote: At 14:17 -0800 3/5/04, John Ling wrote: I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed

Relationship between libz and libmysqlclient libraries

2004-03-05 Thread John Ling
I notice that, while building C applications that use the libmysqlclient library, I sometimes need to link with libz library, depending on which system I am compiling on. The different systems have different mysql versions installed, so is this due to the difference in the versions? Can someon