Riddhi Valecha

Riddhi Valecha

  • 440
  • 3.3k
  • 415.6k

Store more than 3crore records

May 13 2015 4:10 AM
Hi..

I have a table -
ID
User
Email
Flag
1
abc
[email protected]1
2
def
[email protected]1
3
ghi
[email protected]
1

Now....
ID- PK - Auto Increment
User - PK
Email - PK
Flag - bit - 0 or 1 i.e. true or false
----
I have total of 3 crores records to be stored in this table..

And in future... the number will increase...

My query is -
Which database is proper - Oracle / SQL ??
Or should I store it in a file - NoSQL Concepts ?

How to make this ID - infinite... without upper limit ??

Please guide ! It is a bit urgent !

Answers (2)