HELP PLZ --- No Indexes??
Hi Brian Aker
you wrote
>>Archive does not support indexes. Have you tried MyISAM?
I'm currently using MyISAM with indexes. But it consumes alot of disk space (20 times more then archive including index). Also only archive engine can insert ~100,000 records per second in database.
#########
Question
#########
I'm trying to (insert) store data in partitioned Archive engine table. While retrieval I'm temporarily storing few million records in Memory table having index. But scanning one partition with 500Million records takes huge time. IS THERE ANY WAY TO SCAN BIG PARTITION FAST ( without index :( )?
Thank you,
IR
Subject
Views
Written By
Posted
9915
August 29, 2005 04:28AM
6281
August 29, 2005 06:03AM
5822
August 29, 2005 12:37PM
5654
August 29, 2005 01:30PM
5647
August 29, 2005 02:20PM
5378
September 06, 2005 03:49PM
5603
November 07, 2005 07:42PM
5635
November 30, 2005 05:45PM
5467
February 14, 2007 11:23PM
5503
February 15, 2007 10:10AM
5374
February 15, 2007 12:06PM
HELP PLZ --- No Indexes??
5768
February 18, 2007 03:50AM
5511
February 19, 2007 05:55AM
5386
February 22, 2007 04:37PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.