I am considering making a very simple but very large database on my server.
It will have only two fields:
Owner: Will be an integer up to 8 digits (non-unique)
Item: Will be 12 characters (Alpha-numeric)
There will be up to 90 million records, each containing these two fields.
I want to know if that will work on my server and how long it will take to do a simple search on that database, as well as to add records.
A sample search would be to return all Items for a certain Owner…