MySQL Forums :: Newbie :: How long does a query take?


Advanced Search

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


Subject Written By Posted
How long does a query take? Sus Andersson 06/17/2010 06:46AM
Re: How long does a query take? Large Arnaud 06/17/2010 07:21AM
Re: How long does a query take? Sus Andersson 06/17/2010 08:15AM
Re: How long does a query take? Large Arnaud 06/17/2010 08:37AM
Re: How long does a query take? Rick James 06/17/2010 10:51PM
Re: How long does a query take? Sus Andersson 06/18/2010 05:46AM
Re: How long does a query take? Rick James 06/18/2010 10:14AM
Re: How long does a query take? Sus Andersson 06/21/2010 01:28PM
Re: How long does a query take? Rick James 06/21/2010 06:35PM
Re: How long does a query take? Sus Andersson 06/22/2010 04:37AM


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.