| LONG RAW performance problem [message #65469] |
Tue, 28 September 2004 16:58 |
typhoon
Messages: 1
Registered: September 2004
|
Junior Member |
|
|
hi, I need help to solve a strange problem related to LONG RAW.
My Oracle9i table is created as
CREATE TABLE test (id LONG, content LONG RAW, PRIMARY KEY (id))
Then I did something like this:
1> INSERT INTO test VALUES (1, new byte[[1024 * 1024]])
2> for (int i = 0; i < 1000; i++)
UPDATE test SET content=new byte[[1024 * 1024]]
3> DELETE FROM test
Now querying the EMPTY table shows a surpring performance result:
SELECT id FROM test 0.03s
SELECT * FROM test 76.21s
Other information:
1> The meta data shows that the table has used 330472 pages
2> UPDATEs more, performs worse
3> Rebuilding the primary key index doesn't solve the problem
4>
does solve the problem but we cann't
do that in the real application
Does anyone have a solvent to this problem? Thanks a lot!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
