Re: HELP --- No Indexes??
Hi Brian Aker
You wrote
>>You have partitioned index support in 5.1, but that is it for the moment. The >>engine was designed for large summaries.
Q0:- Plz let me know how to use partitioned index / sparse index in Archive Engine. Where can i find documentation & examples.
Archive engine table uses very small disk space & provides better insertion performance (100,000 inserts/sec) than MyISAM. BUT very slow in retrieval!!!!
########
PROBLEM
########
Q1:- My Archive engine table has 300 partitions each having 500Million records. How to create SPARCE INDEX / PARTITIONED INDEX to INCREASE retrieval performance???
Q2:- IF ARCHIVE IS NOT GOING TO HELP, WHAT SHOULD I DO???
Q3:- SHOULD I MOVE TO MS SQL SERVER or ORACLE?
Thank you,
IR.
Edited 1 time(s). Last edit at 02/14/2007 11:28PM by Ijaz Rashid.
Subject
Views
Written By
Posted
9904
August 29, 2005 04:28AM
6275
August 29, 2005 06:03AM
5816
August 29, 2005 12:37PM
5648
August 29, 2005 01:30PM
5641
August 29, 2005 02:20PM
5373
September 06, 2005 03:49PM
5596
November 07, 2005 07:42PM
5614
November 30, 2005 05:45PM
Re: HELP --- No Indexes??
5459
February 14, 2007 11:23PM
5488
February 15, 2007 10:10AM
5368
February 15, 2007 12:06PM
5759
February 18, 2007 03:50AM
5503
February 19, 2007 05:55AM
5374
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.