how to program html website to read 30 million Options

[Treewebe]

Hi,

I would like to create a website like this one
https://cellphonetrackers.org/gsm/gsm-tracker.php

I have a file which contains about 30 million cells in a table
When I enter value of : MCC, MNC, LAC, CID
it gives me some result which is the 5th column of that table

I would like to know how I could read those cells in a website from a file or any other way and then get the response quickly when I enter values like mcc, mnc, etc..?
Which programming language or notion should I use with HTML?

Best regards,

This post has been edited by Treewebe: Nov 28 2017, 09:07 PM

[Christian J]

30 million cells might be too much for a static HTML table, but if the size is manageable you might search them with javascript.

Otherwise you could put them in text file on the server (known as a flat file DB) which can then be searched by a HTML form and e.g. a PHP script directly, or you could also use a proper database (paid web hosts offer that) and a DB base query (with e.g. MySQL).

To query a DB quickly (as soon as the user enters values, as opposed to submitting a form), you can use Ajax (which is a way for javascript to communicate directly with a serverside script).

So in total you might use HTML, javascript, PHP and a DB query language (e.g. MySQL). There might be readymade packages that simplify the process a little.

[pandy]

30 million cells might be too much for a static HTML table, but if the size is manageable you might search them with javascript.

Scratch "may".

[Christian J]

How much would 30M cells need for the HTML table, one or two Gigabyte? I was thinking with todays connection speeds and computer hardware it could be pulled off.

[pandy]

Just 30 M table rows with a single cell with 15 digits in it is close to 1 GB if you stick to ANSI. On my 200 Mb fiber connection that would take about 40 minutes to download, provided I did the math right and I really got 200 Mb, which I don't. In addition to that I think the browser would freeze at an early stage. Not to think of what would happen if you tried to apply JS to that monster.

[Christian J]

You're absolutely right about 1GB, not sure what I was thinking there. That leaves server-side scripting then, probably a database.

[pandy]

And then I didn't count the 30 M - 1 line breaks. But maybe it doesn't need to be pretty.