Re: Writing to MYD/MYI on low level - Jeff Mathis - com.mysql.lists.java

8 messages in com.mysql.lists.javaRe: Writing to MYD/MYI on low level

From	Sent On	Attachments
Sergei Rodionov	15 Jun 2005 07:34
Kim en Max	15 Jun 2005 11:26
Kim en Max	15 Jun 2005 11:34
Sergei Rodionov	15 Jun 2005 18:10
Jeff Mathis	16 Jun 2005 08:49
JR Ruggentaler	16 Jun 2005 08:59
Ronald Klop	21 Jun 2005 05:42
Kim en Max	21 Jun 2005 06:02

Subject:	Re: Writing to MYD/MYI on low level
From:	Jeff Mathis (jmat...@predict.com)
Date:	06/16/2005 08:49:05 AM
List:	com.mysql.lists.java

this just sounds scary. i don't think i would be by-passing the database and creating your own database files. i think that if you are having performance problems with inserts you should work to optimize your insert code.

just my $0.02

On Jun 15, 2005, at 7:10 PM, Sergei Rodionov wrote:

Hi , Max

Since I was in the dillusion RDBMS systems where invented tho take care of the low level aspects entill your message, you have made me very currious about this topic. May I ask you what's behind the thought a Java object for this task would save you a lot of hasle?

Well, you see, its all nice, and MySQL is fast db and all that, no doubt. But when i need to transform million or few of Java objects into db records - speed of insertion becomes somewhat of issue.

So when i can output binary file in 15 mins or less, and insertion of same amount of data takes at least 4 times more - I am starting to look for other meanings of getting data in db (like writing separate table on low level, and then do batch merge).

That would be the reason to look at the low level output.

Cheers Sergei