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
10174
August 29, 2005 04:28AM
6376
August 29, 2005 06:03AM
5941
August 29, 2005 12:37PM
5763
August 29, 2005 01:30PM
5752
August 29, 2005 02:20PM
5468
September 06, 2005 03:49PM
5702
November 07, 2005 07:42PM
6093
November 30, 2005 05:45PM
Re: HELP --- No Indexes??
5575
February 14, 2007 11:23PM
5637
February 15, 2007 10:10AM
5499
February 15, 2007 12:06PM
5880
February 18, 2007 03:50AM
5620
February 19, 2007 05:55AM
5477
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.