Saturday, 7 September 2013

using dbms_pipe to insert data coming from heavy transaction

using dbms_pipe to insert data coming from heavy transaction

I have an application where very frequently data is coming. Data is
string[word] and int value, which i am inserting into database for further
processing. Insort I am using mysql C++ connection.
I am accessing mysql from c++ envioronment. Initially I though to call
insert query for each in coming data and insert into database. Then got
suggestion that it will become very costly and unappropriate to make query
for each such insert when there very high frequency of data insert.
I got suggestion to use dbms_pile. I have not used it before, I read
documentation and got the concept.
I think this feature : Triggers and stored procedures can send debugging
information to a pipe. Another session can keep reading out of the pipe
and display it on the screen or write it to a file this feature will
suffice me requirement, right? Rather write it to file I can insert into
database without display. Ref: Dbms_pipe
Will it suffice?
Will it make any difference?
can someone show me piece of implementation or reference?

No comments:

Post a Comment