re: C++ equivalent type to Oracle's rowid.
Date: Mon, 23 Mar 2009 21:00:16 -0700 (PDT)
What is the C/C++ equivalent to Oracle's rowid?
Currently I am using OTL 4.0 and passing/returning rowids to Oracle stored procedures e.g.:
insert into ... values( .. ) returning rowid into rw_id; # returning
update ... set .. where rowid=ord_id; # passing in id
Right now my C/C++ type is char.
As aside I was benchmarking a design which uses a unique primary index to perform the updates like this:
update ... ser where order_id=ord_id and order_date=ord_date;
vs. a design in which there were NO/ZERO indexes and the update was done like:
update ... set .. where rowid=id;
Unexpectedly the indexed version generally out performs the rowid approach. I was thinking that passing around 19 byte rowids and/or implicit chartorowid()/rowidtochar() were slowing down the rowid version.
Shane Received on Mon Mar 23 2009 - 23:00:16 CDT