faheemrao_at_yahoo.com (FaheemRao) wrote in message news:<43b58913.0110021349.2dc275f3_at_posting.google.com>...
> I want to insert many rows in one Database Call.
>
> like in the Insert SQL statement
>
> insert table_name values(........);
>
> but this will insert only one row in the database.
>
> My Application code is inserting a huge amount of data at one time, so
> it is taking a longgggg time to insert thousands of records.
>
> My application is connected to Oracle through ODBC.
>
> so I need something through which I can insert X number of rows at one
> database call so to take les time.
I must agree with Sybrand words speed and ODBC doesn't fit together,
maybe only if we use term "lack of speed". :-)
I do not know what you meant when you've said "huge amount od data".
What's huge ? 1.000 rows or 100.000 rows or 10.000.000 ? However I do
not think that you will encounter good speeds when using big inserts
through application, especially when we talk about ODBC. If you have
to insert 1.000.000+ rows on daily basis, then can be a good idea to
use SQL*Loader and not your application. You can have this task
automated . For example your application can prepare data as text file
with rigid structure, then you can use ftp (can run without human
touch) to put this file on your server and SQL*loader runned by cron
process can upload this rows to your database. After some testing it
can do your job without errors and with no need for operator. You can
except that your rows will be uploaded in no time comparing to
application aproach.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Wed Oct 03 2001 - 02:01:49 CDT
