MyISAM or Insert Issue or MySQL Server Issue? *pulls hair*

[sgkdnay]

I've tried everything, tweaking setting, re-code my VB6 and for the life of me, I couldn't figure out what I'm doing wrong.

I have 14k rows of data in my text file which is subsequently read into datagrid then it would attempt to update the table in database.

Now the issue is that everytime I run this insert statement, it will ONLY insert 3.9k records instead of 14k records into MySQL Server database? What am I doing wrong? I'm using MyISAM Engine and everything is at default and done locally. Is it because my computer is too fast to insert record or what? Everything is done locally.

What could I have done wrong to configure my MySQL Server? Or to tell VB6 to "slow down" or what?!?

Thanks

 

[DonQuichote]

It could be that there is a setting in my.cnf that limits the size of the queries.

+++ Despite being wrong in every important aspect, that is a very good analogy +++
Hex (in Darwin's Watch)

 

[sgkdnay]

Thats the answer I was really looking for. I stand correct that the system was too fast for mySQL to keep up with all those "chuck" of data to it's queue, no matter how much I tried to tweak it. Hence I had to "reprogram" my VB to loop into certain chucks to allow mySQL some time to add some rows into the database...

This is where I found good information that I thought might be useful to someone:

http://www.dbforums.com/showthread.php?t=1606555

 

[ingresman]

how odd, does this imply that mysql inserts are asynchronous
i.e it will return to the caller before its finished doing its work ?
Where your 3.9k records always the same ones ?