Sample Header Ad - 728x90

Select cleaned Adress Data in an Database

-1 votes
1 answer
60 views
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