MySQL Forums
Forum List  »  Perl

MySQL performance over DB_File
Posted by: hoscalek
Date: September 07, 2006 03:40PM

just more a general question. I have a working Perl script to read some text files and create index consisting of roughly 700,000 rows. Originally I was using Perl native DB_File/DBM database (and tying it with a hash in the program). When I replaced this DB_File database machine with MySQL, the otherwise identical program is now running approx. 4 times slower. Is it an inevitable performance degradation (as the MySQL system is more robust and thus has more overhead), or should it be improvable by better setting up of the MySQL server/connection parameters? So far I was tweaking with memory allocation and query cashing and improved it substantially from the originally unusable state but was not able to match the performance of DB_File.

Thanks, marek

Options: ReplyQuote


Subject
Written By
Posted
MySQL performance over DB_File
September 07, 2006 03:40PM
September 07, 2006 11:03PM
September 10, 2006 02:42PM
September 10, 2006 09:26PM
September 12, 2006 03:46PM


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.