Re: HELP! need sparse index for archive engine tables!!!
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
11567
February 15, 2007 03:48AM
5853
February 16, 2007 06:52AM
Re: HELP! need sparse index for archive engine tables!!!
6027
February 18, 2007 03:51AM
15611
February 19, 2007 05:56AM
5985
February 27, 2007 06:51PM
6108
March 04, 2007 01:29AM
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.