CODEWITHSUNDEEP
phpmysqldatabaseperformancefile
Henrique
Henrique

Reputation: 529

Which is faster? 1 Million lines array or database?

In a PHP script, I got a set of params (zip codes / addresses) that will not change frequently, so I'm looking to move this particular db table to a config file. Would it be faster reading a file containing an array with 1 million lines with zip codes as keys or a db table to scan and get the remaining items of the address (street, city, state).

Thanks,

Upvotes: 0

Views: 255

Answers (2)

shivanshu patel
shivanshu patel

Reputation: 778

Try to store data in database rather than file.for million line i guess database if faster than file.

if you want to achieve performance you can use cache like APCCache or use index in databse over zip field.

sphinx is opensource index which allows faster performance over text search.

Upvotes: 1

nstein
nstein

Reputation: 349

Based on the number of zip codes I'd say go with the DB instead of the associative array. And you'll be able to search either addresses or zip codes or even ids.

Upvotes: 0

Related Questions