how to best approach a massive list?

how to best approach a massive list?

am 07.11.2007 19:05:05 von Richard

I've been working on a massive project for several months. Basically it is
all primarily text with the display showing up in table format.

Basically, one table would show the 3 primary items. Then the second table
would show a calendar, with 3 rows of info. The calendar would be a simple
weekly report thing. Not daily.

Instead of showing each and every item on one huge page, I was thinking of
perhaps showing just one. The user would click on the list of "names" and
then a table would show up displaying the findings.

Question is, which format would be best suited for this? I am kind of
leaning towards PHP but know diddly squat about it. Any one have any clues
or perhaps a website that might show something similar?

Yeah I know you guys are gonna ask for a link to the material. Don't have
one yet. I know it's sketchy but it's the best I can do for now.

But here's one idea I had played with.

item1item2item3


January


18152229
9999999999


Multiply that 1000 times and you soon see just how huge of a page that
would be. I would not be showing all 12 months, at the most, maybe 6.

Re: how to best approach a massive list?

am 07.11.2007 20:43:19 von Bone Ur

Well bust mah britches and call me cheeky, on Wed, 07 Nov 2007 18:05:05
GMT richard scribed:

> I've been working on a massive project for several months. Basically
> it is all primarily text with the display showing up in table format.
>
> Basically, one table would show the 3 primary items. Then the second
> table would show a calendar, with 3 rows of info. The calendar would
> be a simple weekly report thing. Not daily.
>
> Instead of showing each and every item on one huge page, I was
> thinking of perhaps showing just one. The user would click on the list
> of "names" and then a table would show up displaying the findings.
>
> Question is, which format would be best suited for this? I am kind of
> leaning towards PHP but know diddly squat about it. Any one have any
> clues or perhaps a website that might show something similar?
>
> Yeah I know you guys are gonna ask for a link to the material. Don't
> have one yet. I know it's sketchy but it's the best I can do for now.
>
> But here's one idea I had played with.
>
>

item1item2item3

>
> January
>
>
>
18152229
9999999999

>
> Multiply that 1000 times and you soon see just how huge of a page that
> would be. I would not be showing all 12 months, at the most, maybe 6.
>
>

Er, 1000 times what you've shown would be 1000 months, not 6. Math
impaired?

--
Bone Ur
Cavemen have formidable pheromones.

Re: how to best approach a massive list?

am 07.11.2007 23:07:02 von mbstevens

richard wrote:
> I've been working on a massive project for several months. Basically it is
> all primarily text with the display showing up in table format.
>
> Basically, one table would show the 3 primary items. Then the second table
> would show a calendar, with 3 rows of info. The calendar would be a simple
> weekly report thing. Not daily.
>
> Instead of showing each and every item on one huge page, I was thinking of
> perhaps showing just one. The user would click on the list of "names" and
> then a table would show up displaying the findings.
>
> Question is, which format would be best suited for this? I am kind of
> leaning towards PHP but know diddly squat about it.

Anyone reading the post so far is likely to be confused.
There are tables on a webpage, indicated by

and there are tables
on databases like SQL; they are different things, and each has its own format.
PHP is not a format, it is a programming language that can be used for
programming web pages along with SQL or other databases.


> Any one have any clues
> or perhaps a website that might show something similar?
>
> Yeah I know you guys are gonna ask for a link to the material. Don't have
> one yet. I know it's sketchy but it's the best I can do for now.
>
> But here's one idea I had played with.
>
>
item1item2item3

>


> January
....Whup! That dog won't hunt.


>
>
>
18152229
9999999999

>
> Multiply that 1000 times and you soon see just how huge of a page that
> would be. I would not be showing all 12 months, at the most, maybe 6.

Use PHP, Perl, Ruby, or Python to access a data base and rewrite pages
on the fly. Google each of those languages along with HTML, SQL, and CGI.
Rewrite the page given initial user input.

Re: how to best approach a massive list?

am 08.11.2007 00:45:47 von Richard

On Wed, 7 Nov 2007 19:43:19 +0000 (UTC), Bone Ur wrote:

> Well bust mah britches and call me cheeky, on Wed, 07 Nov 2007 18:05:05
> GMT richard scribed:
>
>> I've been working on a massive project for several months. Basically
>> it is all primarily text with the display showing up in table format.
>>
>> Basically, one table would show the 3 primary items. Then the second
>> table would show a calendar, with 3 rows of info. The calendar would
>> be a simple weekly report thing. Not daily.
>>
>> Instead of showing each and every item on one huge page, I was
>> thinking of perhaps showing just one. The user would click on the list
>> of "names" and then a table would show up displaying the findings.
>>
>> Question is, which format would be best suited for this? I am kind of
>> leaning towards PHP but know diddly squat about it. Any one have any
>> clues or perhaps a website that might show something similar?
>>
>> Yeah I know you guys are gonna ask for a link to the material. Don't
>> have one yet. I know it's sketchy but it's the best I can do for now.
>>
>> But here's one idea I had played with.
>>
>>

item1item2item3

>>
>> January
>>
>>
>>
18152229
9999999999

>>
>> Multiply that 1000 times and you soon see just how huge of a page that
>> would be. I would not be showing all 12 months, at the most, maybe 6.
>>
>>
>
> Er, 1000 times what you've shown would be 1000 months, not 6. Math
> impaired?

Yes you are apparently.
I was speaking of 1,000 times the data shown, not months.

Re: how to best approach a massive list?

am 08.11.2007 00:48:45 von Richard

On Wed, 07 Nov 2007 16:07:02 -0600, mbstevens wrote:

> richard wrote:
>> I've been working on a massive project for several months. Basically it is
>> all primarily text with the display showing up in table format.
>>
>> Basically, one table would show the 3 primary items. Then the second table
>> would show a calendar, with 3 rows of info. The calendar would be a simple
>> weekly report thing. Not daily.
>>
>> Instead of showing each and every item on one huge page, I was thinking of
>> perhaps showing just one. The user would click on the list of "names" and
>> then a table would show up displaying the findings.
>>
>> Question is, which format would be best suited for this? I am kind of
>> leaning towards PHP but know diddly squat about it.
>
> Anyone reading the post so far is likely to be confused.
> There are tables on a webpage, indicated by

and there are tables
> on databases like SQL; they are different things, and each has its own format.
> PHP is not a format, it is a programming language that can be used for
> programming web pages along with SQL or other databases.
>
>
>> Any one have any clues
>> or perhaps a website that might show something similar?
>>
>> Yeah I know you guys are gonna ask for a link to the material. Don't have
>> one yet. I know it's sketchy but it's the best I can do for now.
>>
>> But here's one idea I had played with.
>>
>>
item1item2item3

>>
>
>
>> January
> ...Whup! That dog won't hunt.
>

Wow! Hey look typo flame!



>
>>
>>
>>
18152229
9999999999

>>
>> Multiply that 1000 times and you soon see just how huge of a page that
>> would be. I would not be showing all 12 months, at the most, maybe 6.
>
> Use PHP, Perl, Ruby, or Python to access a data base and rewrite pages
> on the fly. Google each of those languages along with HTML, SQL, and CGI.
> Rewrite the page given initial user input.

sanku muchos graxias comrade.

Re: how to best approach a massive list?

am 08.11.2007 00:53:01 von Andy Dingley

On Wed, 7 Nov 2007 12:05:05 -0600, richard wrote:

>I've been working on a massive project for several months. Basically it is
>all primarily text with the display showing up in table format.
>
>Basically, one table would show the 3 primary items. Then the second table
>would show a calendar, with 3 rows of info. The calendar would be a simple
>weekly report thing. Not daily.

How many "blocks" do you need to show in the second table _at_one_time_?

If this is a lot, maybe because you need to print it in one section,
then just generate the tables easily with PHP or whatever and output
them as a very long piece of HTML. Make sure it's well-formed and valid
HTML, where each

itself is quite short. If you do that, it'll
still be "reasonably" quick to download and render, even for a large
amount of data. If a
stretches over the whole of a very long
page, then it can be slow to load.

If you only ever ned to show one "block" at a time, then investigate
AJAX.

Re: how to best approach a massive list?

am 08.11.2007 02:50:14 von Bone Ur

Well bust mah britches and call me cheeky, on Wed, 07 Nov 2007 23:45:47 GMT
richard scribed:

>>> But here's one idea I had played with.
>>>
>>>

item1item2item3

>>>
>>> January
>>>
>>>
>>>
18152229
9999999999

>>>
>>> Multiply that 1000 times and you soon see just how huge of a page that
>>> would be. I would not be showing all 12 months, at the most, maybe 6.
>>>
>>>
>>
>> Er, 1000 times what you've shown would be 1000 months, not 6. Math
>> impaired?
>
> Yes you are apparently.
> I was speaking of 1,000 times the data shown, not months.

Oh, I see. -Grammar impaired.

--
Bone Ur
Cavemen have formidable pheromones.

Re: how to best approach a massive list?

am 08.11.2007 03:08:25 von John Hosking

Bone Ur wrote:
> Well bust mah britches and call me cheeky, on Wed, 07 Nov 2007 23:45:47 GMT
> richard scribed:
>
>>>> But here's one idea I had played with.
>>>>
>>>>

item1item2item3

>>>>
>>>> January
>>>>
>>>>
>>>>
18152229
9999999999

>>>>
>>>> Multiply that 1000 times and you soon see just how huge of a page that
>>>> would be. I would not be showing all 12 months, at the most, maybe 6.

Multiply it 2,645.29 times and you soon wonder why you're doing it.

>>>>
>>>>

What's this for, to grill a hamburger with? To warm my heart's cockles?

>>> Er, 1000 times what you've shown would be 1000 months, not 6. Math
>>> impaired?
>> Yes you are apparently.
>> I was speaking of 1,000 times the data shown, not months.

....in which the data shown seems to be for one month...

>
> Oh, I see. -Grammar impaired.

If he's told you once, he's told you: 1,000 times.
;-)

--
John
Pondering the value of the UIP: http://improve-usenet.org/

Re: how to best approach a massive list?

am 08.11.2007 05:12:31 von Richard

On Wed, 07 Nov 2007 23:53:01 +0000, Andy Dingley wrote:

> On Wed, 7 Nov 2007 12:05:05 -0600, richard wrote:
>
>>I've been working on a massive project for several months. Basically it is
>>all primarily text with the display showing up in table format.
>>
>>Basically, one table would show the 3 primary items. Then the second table
>>would show a calendar, with 3 rows of info. The calendar would be a simple
>>weekly report thing. Not daily.
>
> How many "blocks" do you need to show in the second table _at_one_time_?
>
> If this is a lot, maybe because you need to print it in one section,
> then just generate the tables easily with PHP or whatever and output
> them as a very long piece of HTML. Make sure it's well-formed and valid
> HTML, where each

itself is quite short. If you do that, it'll
> still be "reasonably" quick to download and render, even for a large
> amount of data. If a
stretches over the whole of a very long
> page, then it can be slow to load.
>
> If you only ever ned to show one "block" at a time, then investigate
> AJAX.

One of my other ideas is to go ahead and the table thing as above but use
iframes. The first table would be on the main "index" page, then the
2nd table shows up on the iframe. Using only a handfull of pages and
anchors, paging would not be all that much of a problem.

Re: how to best approach a massive list?

am 08.11.2007 05:49:10 von Adrienne Boswell

Gazing into my crystal ball I observed richard writing
in news:fgsr9e027og@news1.newsguy.com:

> I've been working on a massive project for several months. Basically
> it is all primarily text with the display showing up in table format.
>
> Basically, one table would show the 3 primary items. Then the second
> table would show a calendar, with 3 rows of info. The calendar would
> be a simple weekly report thing. Not daily.
>
> Instead of showing each and every item on one huge page, I was
> thinking of perhaps showing just one. The user would click on the list
> of "names" and then a table would show up displaying the findings.
>
> Question is, which format would be best suited for this? I am kind of
> leaning towards PHP but know diddly squat about it. Any one have any
> clues or perhaps a website that might show something similar?
>

Server side with a database. Loop through the records with a link to
the data, then use the querystring object to query the db table for that
record(s). Any server side language will do, and a database. Probably
PHP and Mysql or you could go with ASP and Access.

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share

Re: how to best approach a massive list?

am 08.11.2007 09:16:17 von Bone Ur

Well bust mah britches and call me cheeky, on Thu, 08 Nov 2007 02:08:25
GMT John Hosking scribed:

>>>>> But here's one idea I had played with.
>>>>>
>>>>>

item1item2item3

>>>>>
>>>>> January
>>>>>
>>>>> >>>>> r>
>>>>>
18152229
9999999999

>>>>>
>>>>> Multiply that 1000 times and you soon see just how huge of a page
>>>>> that would be. I would not be showing all 12 months, at the most,
>>>>> maybe 6.
>
> Multiply it 2,645.29 times and you soon wonder why you're doing it.

Hey, math always makes me wonder why I'm doing it...

>>>>>
>>>>>
>
> What's this for, to grill a hamburger with? To warm my heart's
> cockles?

'Course. Ya can't go around with cold cockles, can ya?

>>>> Er, 1000 times what you've shown would be 1000 months, not 6. Math
>>>> impaired?
>>> Yes you are apparently.
>>> I was speaking of 1,000 times the data shown, not months.
>
> ...in which the data shown seems to be for one month...
>
>>
>> Oh, I see. -Grammar impaired.
>
> If he's told you once, he's told you: 1,000 times.
> ;-)

It must be the echo...

--
Bone Ur
Cavemen have formidable pheromones.

Re: how to best approach a massive list?

am 08.11.2007 12:24:17 von Andy Dingley

On 8 Nov, 04:12, richard wrote:

> One of my other ideas is to go ahead and the table thing as above but use
> iframes.

Poor man's AJAX

Use some JavaScript to set the .src property on the