Re: bulk loading of data

2004-09-26 Thread Eldo Skaria
Hi David, I think you can try pipes(hope u r using linux/unix). this is a method we used to export/sqlload for oracle. craete a pipe file, say abc.txt(mkfile -p abc.txt). start the the dumpfile reading in bg(should be run first). start the dump-file generation of C++. with this setup we could

bulk loading of data

2004-09-24 Thread David Mehringer
Hello, I have a C++ application which spits out data continuously which I need to load into a database. The data rate is roughly 50,000 rows * 50 bytes/row per second. I use LOAD DATA INFILE (the quickest way I can find to load data into the db) to load these data into MyISAM tables which is

Re: bulk loading of data

2004-09-24 Thread mos
At 03:28 PM 9/24/2004, you wrote: Hello, I have a C++ application which spits out data continuously which I need to load into a database. The data rate is roughly 50,000 rows * 50 bytes/row per second. I use LOAD DATA INFILE (the quickest way I can find to load data into the db) to load these data