Re: HELP PLZ --- No Indexes??
Hi,
My company is going to launch new product. Our competitor is using MS SQL Server. They are storing data and index in very small foot print in *.std and *.onx files respectively.
I've chosen MySQL database Archive Engine due to its small storage size and fast rate of insertion.
My RnD is badly affecting due to very slow retrieval performance.
Reason being limited to 1024 partitions on windows platform and non avilibility of index. (each partition contains +500Million records)
The success and failure of our product is based on retrieval performance of data.
Please let us have at least on index on (ID int, Time datetime) columns.
We are unable to use MyISAM bcz we can't get close to storage + insertion efficiency of competitor.
Thank you,
IR
Subject
Views
Written By
Posted
10175
August 29, 2005 04:28AM
6377
August 29, 2005 06:03AM
5943
August 29, 2005 12:37PM
5764
August 29, 2005 01:30PM
5753
August 29, 2005 02:20PM
5469
September 06, 2005 03:49PM
5704
November 07, 2005 07:42PM
6094
November 30, 2005 05:45PM
5576
February 14, 2007 11:23PM
5638
February 15, 2007 10:10AM
5500
February 15, 2007 12:06PM
5881
February 18, 2007 03:50AM
Re: HELP PLZ --- No Indexes??
5620
February 19, 2007 05:55AM
5478
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.