Re: Optimize Insert

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 15 Jan 2005 08:58:32 -0800
Message-ID: <p6WdnT5Hr7E41nTcRVn-iA@comcast.com>

"Sascha Bahl" <sbahl_at_test.com> wrote in message news:MPG.1c4daed0ed10cc7b9896af_at_news.individual.net...
> Hello!
>
> How can i optimize inserts into table? Under MySQL i can use value lists
> to collect many of records. How can i insert many of record in one
> insert statement?
>
> Thanks
>
> Sascha Bahl

Most programmatic interfaces support an array interface in Oracle. Use that. For example, OCI supports an array interface and it is very efficient. Also USE BIND VARIBLES! You will avoid parsing (lower cpu usage).
Jim Received on Sat Jan 15 2005 - 10:58:32 CST