Skip to main content

New answers tagged

1 vote

Text files vs. MySQL Performance for Large Dataset

A database sounds suitable for your use case. If you use indices appropriately it should provide very fast lookups, on the order of tens to hundreds of milliseconds. But possibly the greatest ...
JonasH's user avatar
  • 5,824
2 votes

Text files vs. MySQL Performance for Large Dataset

Storing data in memory with a hash table lookup will be faster than any remote database (assuming the same specs) due to the network latency. Hash tables offer O(1) lookup complexity, while MySQL with ...
Lem's user avatar
  • 21

Top 50 recent answers are included