| Record Groups VS Table types [message #117954] |
Mon, 02 May 2005 02:12  |
mathan
Messages: 24
Registered: March 2005
|
Junior Member |
|
|
Hi,
In forms, I am storing some values in a plsql table(like an array). Everytime a value is chosen in the filter, I do a sequential search of the table to retrieve my values. As this is a single table the search is taking a long time.I would like to replace this with multiple run time record groups. My question is whether the storing and retrieval from record groups are in any way faster or slower than retrieval from a table? I dont know the exact row number. So I have to do a sequential read of the record group also. So it will be something like :
for i in 1..10 loop
v := get_group_char_Cell('col name',i);
end loop;
Is this faster than
for i in 1..10 loop
v := tab(i).col;
end loop;
Ps: The record group could be smaller than the table as it will be multiple. Table will be always be one.
Thanks in Advance.
|
|
|
|
|
|
|
|
|
|
| Re: Record Groups VS Table types [message #118328 is a reply to message #118094] |
Wed, 04 May 2005 07:43  |
mathan
Messages: 24
Registered: March 2005
|
Junior Member |
|
|
Hi,
Want to add one more question. If I use a GLOBAL TEMP table instead of a plsql table or a record group, would that be faster? Especially if the GLOBAL table is indexed?
Please help!
Thanks
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
