I have 80.000.000 Entries about Persons. They are built up like:
Max;Mustermann;Examplestreet;50;9900;City
88000 is one ZIP Code, 8800 Zip Codes exist.
I want to find out the entry based on Street/Housenumber/ZIP/City as fast as possible.
**The idea:**
Setting up 88 Databases for the first 2 numbers of the ZIP code. In this case its 99.
In the Database i use the first 2 letters for the Street selection and create a table for that.
In this Case EX.
If i assume that the DB 99 has max 2.000.000 Database entries, EX will maximum have 100.000.
How can i find entries fast in this 100.000 ?
Asked by Ploetzeneder
(189 rep)
Feb 28, 2014, 10:05 AM
Last activity: Apr 8, 2015, 01:11 PM
Last activity: Apr 8, 2015, 01:11 PM