Re: HELP! need sparse index for archive engine tables!!!

[Ijaz Rashid]

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