Re: MySQL performance over DB_File
Posted by:
hoscalek
Date: September 12, 2006 03:46PM
Bill, thank you for suggestions.
Ad 1) I read the forum discussion about prepare and query cache, and I understand that unless I specify mysql_server_prepare=1 in the connection, the prepare works only on the client's side (Perl program), but the query cache on the server side is in my opinion utilised. Is there any (performance) advantage from forcing server-side prepare?
Ad 2) I actually use the similar workaround as you suggested. I have an original version of the Perl script, to the end of which I just added loading the hash content into MySQL table. However, this would suggest a positive answer to my original question whether using MySQL during the program is systematically slower over the use of DB_File.
Anyway, I will try to experiment with the optimization as described in the manual.
Marek
Subject
Written By
Posted
September 07, 2006 03:40PM
September 07, 2006 11:03PM
September 10, 2006 02:42PM
September 10, 2006 09:26PM
Re: MySQL performance over DB_File
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.