Welcome to MobyThreads.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

How can I get the FIRST part of a huge table of date to di..

 
   Web Hosting and Web Master Forums (Home) -> Webmaster RSS
Related Topics:
Huge, dedicated traffic - I was wondering if there is any good way to get massive, dedicated traffic to a site. Other than taking a banner on Yahoo! (right) or something like that. Does anyone have any real ideas? Also, what are the rates for a high traffic site? ..

Huge hole in apache webservers.. - Greetings everyone, This is slightly off topic but I wanted some opinions. Normally, Im a web designer, however, in an ongoing attempt to further my skills, I decided to take on more ability to do RedHat admin stuff, so that I can learn the ins and..

free website (huge files) - Hello Do you know any free web site manager where I can store huge files i.e. gigabytes in size thanks for help

404 Question Part 2 - The last thread kind of went off on a tangent, so I'll pose the question below again. This is not to mess up the search engines because none of the 404 pages are linked to one another. Instead, I just want to give the user the that the page..

PHP: Variable as part of a variable - Here's a confusing one. I want to feed a PHP script a variable value that will be used as part of a variable name when the script runs. $1a = $1b = $1c = else // Run print ("..
Author Message
ship

External


Since: Jun 05, 2007
Posts: 28



(Msg. 1) Posted: Tue Sep 25, 2007 5:44 am
Post subject: How can I get the FIRST part of a huge table of date to display before the whole page downloads?
Archived from groups: alt>www>webmaster (more info?)

Hi

We have a huge table of data to publish on a single page.
Is there a way to get the first screenful (say 50 records) to upload
first?

i.e. Is it enough to put the first 50 records into its own table?
The thing is that due to the construction of the page template
BOTH tables will necessarily be within the same one page.

With thanks


Ship
Shiperton Henethe

 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Andy Dingley

External


Since: Jun 05, 2007
Posts: 69



(Msg. 2) Posted: Tue Sep 25, 2007 8:55 am
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 25 Sep, 13:44, ship <ship... RemoveThis @gmail.com> wrote:

> We have a huge table of data to publish on a single page.
> Is there a way to get the first screenful (say 50 records) to upload
> first?

Use AJAX.

Allow some non-JS backup for the povs too, but you don't have to worry
about the speed of that.


I _wouldn't_ use "LIMIT" (or even "SELECT TOP ..."). It's not the
database's fault that you want to display the first page quickly, so
run the full query and cache the results in the server-side code. If
you limit the query itself, then you have to duplicate the query to
get the rest of the data afterwards. This would have two drawbacks:

* The data might change in the meantime. What happens if entries #49
and #51 swap places? Would one get duplicated and the other omitted?

* It's inefficient. Using TOP means an expensive sort operation on
your large dataset, let alone the cost of selecting the rows in the
first place. Two q

 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
rf

External


Since: Aug 21, 2006
Posts: 26



(Msg. 3) Posted: Tue Sep 25, 2007 9:57 am
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"ship" <shiphen.DeleteThis@gmail.com> wrote in message
news:1190724278.843961.248890@19g2000hsx.googlegroups.com...
>
> Hi
>
> We have a huge table of data to publish on a single page.

Why?

> Is there a way to get the first screenful (say 50 records) to upload
> first?

Not really.

Why is the table so big? URL?

If the table *is* so big then why would I want to download it all anyway?

Hint: As soon as I see my scroll bar progressing up into the top quarter of
my browser window I think: "Aha, I don't need the rest of this" and
invariably hit stop, or more often, back.

--
Richard
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
ship

External


Since: Jun 05, 2007
Posts: 28



(Msg. 4) Posted: Tue Sep 25, 2007 10:39 am
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Sep 25, 6:11 pm, Brian Wakem <n... DeleteThis @email.com> wrote:
> ship wrote:
>
> > Hi
>
> > We have a huge table of data to publish on a single page.
> > Is there a way to get the first screenful (say 50 records) to upload
> > first?
>
> > i.e. Is it enough to put the first 50 records into its own table?
> > The thing is that due to the construction of the page template
> > BOTH tables will necessarily be within the same one page.
>
> I interpretted this question differently from all of those that have
> answered so far.
>
> I am thinking you are suffering from IE's inability to render a table until
> the entire contents is known, something I do not think any other major
> browser suffers from.
>
> I have circumvented this is the past by making my loop output a separate
> table for each row rather than a separate row in the same table.
>

Well... since you ask here is the page in question:
http://www.auctionair.co.uk/High-Bid-Auction/Results.aspx

Why such a big table? Because we want to show SCALE.

Why not on two pages? Because almost no one will find and
bother to click on a small link at the bottom of the page, whereas
if you ask to see some sample results and you get a tonne of
data down it's in your face - you KNOW that there is a lot of it.

OK so we have put the first 50 Lots into it's own HTML table.
The problem is that I can't see if it displays the first 50 before
the rest of the page because we are on broadband and it's uploading
too fast!

I did ask in an earlier post if anyone new of a good way to throttle
my connectivity back down to a sensible level, but no easy answers
yet...


Ship
Shiperton Henethe
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Brian Wakem

External


Since: Sep 07, 2007
Posts: 47



(Msg. 5) Posted: Tue Sep 25, 2007 1:58 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

ship wrote:

>
> Hi
>
> We have a huge table of data to publish on a single page.
> Is there a way to get the first screenful (say 50 records) to upload
> first?
>
> i.e. Is it enough to put the first 50 records into its own table?
> The thing is that due to the construction of the page template
> BOTH tables will necessarily be within the same one page.


I interpretted this question differently from all of those that have
answered so far.

I am thinking you are suffering from IE's inability to render a table until
the entire contents is known, something I do not think any other major
browser suffers from.

I have circumvented this is the past by making my loop output a separate
table for each row rather than a separate row in the same table.


--
Brian Wakem
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Jim Moe

External


Since: Sep 01, 2005
Posts: 44



(Msg. 6) Posted: Tue Sep 25, 2007 1:58 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Brian Wakem wrote:
>>
>> We have a huge table of data to publish on a single page.
>> Is there a way to get the first screenful (say 50 records) to upload
>> first?
>>
>> i.e. Is it enough to put the first 50 records into its own table?
>> The thing is that due to the construction of the page template
>> BOTH tables will necessarily be within the same one page.
>
> I have circumvented this is the past by making my loop output a separate
> table for each row rather than a separate row in the same table.
>
I have a similar solution. When the page is being generated by the
script, the table is broken into multiple tables with a fixed number of
rows, i.e., when the current table reaches a specified number of rows, it
is closed and a new table started.

--
jmm (hyphen) list (at) sohnen-moe (dot) com
(Remove .AXSPAMGN for email)
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
cfajohnson

External


Since: Aug 14, 2004
Posts: 65



(Msg. 7) Posted: Tue Sep 25, 2007 5:09 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 2007-09-25, ship wrote:
> On Sep 25, 6:11 pm, Brian Wakem <n....TakeThisOut@email.com> wrote:
>> ship wrote:
>>
>> > Hi
>>
>> > We have a huge table of data to publish on a single page.
>> > Is there a way to get the first screenful (say 50 records) to upload
>> > first?
>>
>> > i.e. Is it enough to put the first 50 records into its own table?
>> > The thing is that due to the construction of the page template
>> > BOTH tables will necessarily be within the same one page.
>>
>> I interpretted this question differently from all of those that have
>> answered so far.
>>
>> I am thinking you are suffering from IE's inability to render a table until
>> the entire contents is known, something I do not think any other major
>> browser suffers from.
>>
>> I have circumvented this is the past by making my loop output a separate
>> table for each row rather than a separate row in the same table.
>>
>
> Well... since you ask here is the page in question:
> http://www.auctionair.co.uk/High-Bid-Auction/Results.aspx
>
> Why such a big table? Because we want to show SCALE.

That doesn't show scale. Who's going to bother descending more than
a screen or two?

> Why not on two pages?

Better still, 10, 20 or more pages.

> Because almost no one will find and bother to click on a small link

Then use a big link.

> at the bottom of the page,

So put it at the top.

> whereas if you ask to see some sample results and you get a tonne of
> data down it's in your face

No, it's not in my face. It's somewhere off the screen (or not yet
on my computer).

> - you KNOW that there is a lot of it.

You don't think people know what 2,000 means?

> OK so we have put the first 50 Lots into it's own HTML table.

That's a reasonable size for a page. Note the word, "page".

> The problem is that I can't see if it displays the first 50 before
> the rest of the page because we are on broadband and it's uploading
> too fast!

The problem is that you are trying to put too much on a page. A
person on dial-up is more than likely going to leave long before
the page is loaded.

> I did ask in an earlier post if anyone new of a good way
> to throttle my connectivity back down to a sensible level, but no
> easy answers yet...

You are asking the wrong question.

With a broadband connection, the page loads reasonably quickly, but
it is far too big for me to want to look past two or three screens.
You could reduce the amount of scrolling by not limiting the table
to about half the width of my browser window. Each row requires two
lines because it is so narrow.

--
Chris F.A. Johnson <http://cfaj.freeshell.org>
===================================================================
Author:
Shell Scripting Recipes: A Problem-Solution Approach (2005, Apress)
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Brian Wakem

External


Since: Sep 07, 2007
Posts: 47



(Msg. 8) Posted: Tue Sep 25, 2007 6:43 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

ship wrote:

> On Sep 25, 6:11 pm, Brian Wakem <n....TakeThisOut@email.com> wrote:
>> ship wrote:
>>
>> > Hi
>>
>> > We have a huge table of data to publish on a single page.
>> > Is there a way to get the first screenful (say 50 records) to upload
>> > first?
>>
>> > i.e. Is it enough to put the first 50 records into its own table?
>> > The thing is that due to the construction of the page template
>> > BOTH tables will necessarily be within the same one page.
>>
>> I interpretted this question differently from all of those that have
>> answered so far.
>>
>> I am thinking you are suffering from IE's inability to render a table
>> until the entire contents is known, something I do not think any other
>> major browser suffers from.
>>
>> I have circumvented this is the past by making my loop output a separate
>> table for each row rather than a separate row in the same table.
>>
>
> Well... since you ask here is the page in question:


I did not ask.


> http://www.auctionair.co.uk/High-Bid-Auction/Results.aspx
>
> Why such a big table? Because we want to show SCALE.
>
> Why not on two pages? Because almost no one will find and
> bother to click on a small link at the bottom of the page, whereas
> if you ask to see some sample results and you get a tonne of
> data down it's in your face - you KNOW that there is a lot of it.
>
> OK so we have put the first 50 Lots into it's own HTML table.
> The problem is that I can't see if it displays the first 50 before
> the rest of the page because we are on broadband and it's uploading
> too fast!
>
> I did ask in an earlier post if anyone new of a good way to throttle
> my connectivity back down to a sensible level, but no easy answers
> yet...


You could saturate the connection before loading the page.

As I said before, only IE has a problem rendering tables like this, I don't
have IE so I can't help with that part.


--
Brian Wakem
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Karl Groves

External


Since: May 30, 2006
Posts: 452



(Msg. 9) Posted: Tue Sep 25, 2007 8:04 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Brian Wakem <no.DeleteThis@email.com> wrote in
news:5lstqlF9ueq1U1@mid.individual.net:

> ship wrote:
>
>>
>> Hi
>>
>> We have a huge table of data to publish on a single page.
>> Is there a way to get the first screenful (say 50 records) to upload
>> first?
>>
>> i.e. Is it enough to put the first 50 records into its own table?
>> The thing is that due to the construction of the page template
>> BOTH tables will necessarily be within the same one page.
>
>
> I interpretted this question differently from all of those that have
> answered so far.
>
> I am thinking you are suffering from IE's inability to render a table
> until the entire contents is known, something I do not think any other
> major browser suffers from.
>
> I have circumvented this is the past by making my loop output a
> separate table for each row rather than a separate row in the same
> table.

That's really a bad approach. This basically goes against every reason for
using a table in the first place.


--
Karl Groves
http://www.WebAccessStrategies.com
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
rf

External


Since: Aug 21, 2006
Posts: 26



(Msg. 10) Posted: Tue Sep 25, 2007 11:30 pm
Post subject: Re: How can I get the FIRST part of a huge table of date to display before the whole page downloads? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

"ship" <shiphen.TakeThisOut@gmail.com> wrote in message
news:1190741955.655235.290220@y42g2000hsy.googlegroups.com...
> On Sep 25, 6:11 pm, Brian Wakem <n....TakeThisOut@email.com> wrote:
>> ship wrote:

> http://www.auctionair.co.uk/High-Bid-Auction/Results.aspx
>
> Why such a big table? Because we want to show SCALE.

I was right. There was no way I needed to see this.

After the first 50 "lines" you don't even need the database. Simply make up
some random information. Nobody is going to read each and every line.

And this doesn't show scale. It shows IMHO sillyness, wasting 800KB of my
(and your) bandwidth.

--
Richard.
 >> Stay informed about: How can I get the FIRST part of a huge table of date to di.. 
Back to top
Login to vote
Display posts from previous:   
   Web Hosting and Web Master Forums (Home) -> Webmaster All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]