Re: Optimization suggestions

Tables has varchar36 primary keys, because I use UUID and not auto increment columns. I have verified all the queries that are going to run on tables using Explain and it show correct index being used. Thanks SN Sudhir NimavatSenior software engineer. Quick start global PVT LTD. Baro

50M records each year, help me choosing the stretegy

I have come across a requirement where I need to store a very large amount of data in a table. In one of our app.. we can have around 50 Million records each year.. Can any one guide me in choosing a strategy than can handle this load. Thanks SN Sudhir NimavatSenior software engineer