The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> how to program html website to read 30 million
Treewebe
post 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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Nov 29 2017, 07:47 AM
Post #2


.
********

Group: WDG Moderators
Posts: 7,736
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.

User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Nov 29 2017, 06:59 PM
Post #3


Don't like donuts. Don't do MySpace.
********

Group: WDG Moderators
Posts: 17,772
Joined: 9-August 06
Member No.: 6



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
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Nov 30 2017, 06:13 AM
Post #4


.
********

Group: WDG Moderators
Posts: 7,736
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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Nov 30 2017, 05:37 PM
Post #5


Don't like donuts. Don't do MySpace.
********

Group: WDG Moderators
Posts: 17,772
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.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
Christian J
post Nov 30 2017, 06:11 PM
Post #6


.
********

Group: WDG Moderators
Posts: 7,736
Joined: 10-August 06
Member No.: 7



You're absolutely right about 1GB, not sure what I was thinking there. blush.gif That leaves server-side scripting then, probably a database.
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Dec 1 2017, 09:21 AM
Post #7


Don't like donuts. Don't do MySpace.
********

Group: WDG Moderators
Posts: 17,772
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. tongue.gif
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 17th December 2017 - 05:03 AM