Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
tuning insert performance
1 view
Skip to first unread message
Sonal Gupta
Jan 23, 2006, 1:33:44 AM1/23/06
to
Hi ppl,
I am working on an application which uses ODBC and oracle server as DB.
In brief, the app recieves an object , reads the data and insert into
appropriate tables in DB.This obj has got key-value pairs and every jey
has a diff table. So if there are x keys, the app is makin x insert
statement using a persistence connection.This affects the perf.
I am working on an application which uses ODBC and oracle server as DB.
In brief, the app recieves an object , reads the data and insert into
appropriate tables in DB.This obj has got key-value pairs and every jey
has a diff table. So if there are x keys, the app is makin x insert
statement using a persistence connection.This affects the perf.
Now these keys are all independent of eachother. So i hav now cached
all the key-value in memory and want to update the Db in one shot.I
think StoredProcedure can help me here. But i am not able to figure out
how to send whole data to DB using ODBC.
If anyone can gimme some idea abt the same that wud be great.
TIA
0 new messages