windows 2000 server
HP ML370 2.8ghz
1 gb ram
im buying the PAF file (UK) from royal mail and im going to stick it onto this SQL server but i dont know what the performance is going to be like having to search through 27 million records. does anyone else use the PAF file? and what is the CPU, memory usage like searching though this many records? - should i expect it to be really slow?
i guess the final goal will be to have a web page search for a Postcode and return the correct address. ( ADO, iis5, classic ASP ) Intranet, not on web
if anyone thinks this isn't going to work, what minimum spec hardware should i be looking at.