MySQL Forums
Forum List  »  Newbie

How long does a query take?
Posted by: Sus Andersson
Date: June 17, 2010 06:46AM

I am trying to load an xml file of 500MB into a database with the command

Load xml local infile ’c:/test.xml’
Into table medarbetare
Rows identified by ‘<medarbetare>’;

I have tried the command on a small part (50 rows) of the file and it worked fine. But when trying it on the whole file ... it was "thinking" for 4 hours, then I started to suspect something was wrong. Now I can´t stop it.

How long is the loading supposed to take (did I try to break it too early?)

Options: ReplyQuote

Written By
How long does a query take?
June 17, 2010 06:46AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.