Re: Insert speed (JDBC and MySQL)
- From: Roedy Green <my_email_is_posted_on_my_website@xxxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 19:25:53 GMT
On Tue, 24 Jan 2006 14:33:10 +0000, John <no@email> wrote, quoted or
indirectly quoted someone who said :
>Does anyone know how to improve the performance of these INSERTs?
You want to turn off any sort of transaction processing, commits or
failure looks.
Failing that, write a program that execs a fast flat-file import of a
chunk, does something then spans the import of another chunk.
If it is an opensource DB, have a look at the tricks the import uses
to turn off overhead.
--
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.
.
- References:
- Insert speed (JDBC and MySQL)
- From: John
- Insert speed (JDBC and MySQL)
- Prev by Date: Re: Insert speed (JDBC and MySQL)
- Next by Date: Re: Insert speed (JDBC and MySQL)
- Previous by thread: Re: Insert speed (JDBC and MySQL)
- Next by thread: Re: Insert speed (JDBC and MySQL)
- Index(es):
Relevant Pages
|
