We had this problem once with Oracle 7.3. Try analyzing the db and restarting where you
left off.
Dwain Coufal
Systems Analyst II
S&W Health Plan Phcy
Certified HTML Programmer
>>> <jice@stripped> 07/26 8:54 AM >>>
Hi,
I recently installed mysql on a solaris 7/sparc 5 to host a database of
address. Using perl, DBD::mysql to parse text files containing 30,000+
address and then insert into the database. It's all pretty straight
forward. But, there is something that seems to me really strange.
The perl script starts off parsing the text files at a acceptably fast
rate. When it gets around the 1500 address it's moving pretty slow.
i let it run over the weekend and came in Monday morning to find that it
was still running at a rate of 1 line inserted about ever 20 secs. I was
wondering if this is a problem with this port of mysql or perl or how i
code. I've also done something similar to what i described but ran mysql
on a Linux machine and inserted 2.5 million lines that needed a much more
complicated parsing script, and i had much faster results. Any incite or
suggestions would be greatly appreciated.
Thanks in advance,
joe rice
---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail mysql-thread8377@stripped
To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail mysql-unsubscribe@stripped instead.
