Help - Search - Members - Calendar
Full Version: how to program html website to read 30 million
HTMLHelp Forums > Web Authoring > Markup (HTML, XHTML, XML)
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,
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
QUOTE(Christian J @ Nov 29 2017, 01:47 PM) *

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". laugh.gif
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. blush.gif 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. tongue.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2018 Invision Power Services, Inc.