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 !
Riddhi ValechaPosted May 16, 2015, 5:47 AM
I want a solution so that there is absolutely no upper limit...
Eg - Say..IBM is a company throughout the Globe - USA/UK/India/ etc.... all over..
Now, I want to take 1 country... say UK... and want all employees details of IBM in the database...
i.e. a database with emp details of IBM, UK.
Employees can leave, new employees are recruited.... etc... this is never-ending process...
Dipankar BiswasPosted May 15, 2015, 6:03 AM
Check this link to help...http://stackoverflow.com/questions/3779088/database-that-can-handle-500-millions-rows