how to program html website to read 30 million |
how to program html website to read 30 million |
Treewebe |
Nov 28 2017, 09:04 PM
Post
#1
|
Group: Members Posts: 1 Joined: 28-November 17 Member No.: 26,545 |
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 |
Nov 29 2017, 07:47 AM
Post
#2
|
. Group: WDG Moderators Posts: 9,656 Joined: 10-August 06 Member No.: 7 |
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 |
Nov 29 2017, 06:59 PM
Post
#3
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,730 Joined: 9-August 06 Member No.: 6 |
|
Christian J |
Nov 30 2017, 06:13 AM
Post
#4
|
. Group: WDG Moderators Posts: 9,656 Joined: 10-August 06 Member No.: 7 |
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 |
Nov 30 2017, 05:37 PM
Post
#5
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,730 Joined: 9-August 06 Member No.: 6 |
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 |
Nov 30 2017, 06:11 PM
Post
#6
|
. Group: WDG Moderators Posts: 9,656 Joined: 10-August 06 Member No.: 7 |
You're absolutely right about 1GB, not sure what I was thinking there. That leaves server-side scripting then, probably a database.
|
pandy |
Dec 1 2017, 09:21 AM
Post
#7
|
🌟Computer says no🌟 Group: WDG Moderators Posts: 20,730 Joined: 9-August 06 Member No.: 6 |
And then I didn't count the 30 M - 1 line breaks. But maybe it doesn't need to be pretty.
|
Lo-Fi Version | Time is now: 25th April 2024 - 12:29 PM |