Page 1 of 1
Lost connection but only in my code
Posted: Tue 17 May 2005 14:44
by DaveRob
I have a large query (load data infile), and if I run it with mysql client, it is working. Otherwise, when I put it in my code, I get a lost connection but the query is still executing in mysql server. Is there a way to avoid that?
Thanks
Posted: Tue 17 May 2005 15:14
by Serious
This functionality is inaccessible in Direct mode.
To use it set MySqlConnection.Direct=false.
Posted: Wed 13 Jul 2005 14:19
by shutterstock
When executing long inserts - i get the "lost connection" as well.
should i be running in direct=false?
why is this the case?
Posted: Wed 13 Jul 2005 14:26
by Serious
Send us your SQL query.
Posted: Wed 13 Jul 2005 14:28
by shutterstock
It's an INSERT INTO ticks VALUES (56, 12.8, 99, 100)
im inserting about a 1/2 million rows at a time... all stock quotes essentially.
Posted: Wed 13 Jul 2005 14:41
by Serious
If you have Professional license try using MySqlLoader component.
It flushes your data to database according to the internal data buffer filling (Check the BufferSize property).