inster into MySQL DB from excel file

Topics: Developer Forum, Project Management Forum, User Forum
May 16, 2011 at 11:09 PM

Hello!!
I try to read excel files in Prado FrameWork. Now I have a problem, when upload a file with more of 1000 registers the velocity to insert this to MySQL Data Base is low can takes more of 00:01:08 ( 1 min and 8 seconds). Can someone help me whit this issue??
Thanks for your help!

 

Jacck

May 17, 2011 at 2:05 PM

I do an INSERT for each row one at a time with no issues, if that helps.

May 17, 2011 at 2:33 PM

Not, so do it myself, for each row created a new object for my clase and save this.