Re: [PHP] Tables Loading Slow
Check the PHP manual on flush() --Tony On Wed, 2002-01-30 at 08:38, Bryan Gintz wrote: Hi. I have a large database query that returns anywhere from 10-30ish records. The problem comes from loading them in tables. With IE5 and Netscape 5 on windows, the results do not display until the last /table tag is written. Does anyone have any ideas on how to show the results as the come from the query? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Tony Bibbs | Life is a moderately good play [EMAIL PROTECTED] | with a bad 3rd act. 515.554.8046 | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Tables Loading Slow
On Wednesday 30 January 2002 22:38, Bryan Gintz wrote: Hi. I have a large database query that returns anywhere from 10-30ish records. The problem comes from loading them in tables. With IE5 and Netscape 5 on windows, the results do not display until the last /table tag is written. Does anyone have any ideas on how to show the results as the come from the query? It is function of the browser. The only browser that I know of which doesn't wait for the /table before rendering the table is Konqueror. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Anybody can win, unless there happens to be a second entry. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Tables Loading Slow
Good day, As it has been said, this is a function of the browser. You can get around this by not using a large table to render your data. You could use one table per row, with all columns formatted with the same width. You could also try to use SPAN containers to store the data, but in my experience only IE supports the width style attribute of these. You will also have to ensure that PHP is flushing the output as it displays it. And, you could also optimize your data structure so that the results are returned quicker. =) Darren Gamble Planner, Regional Services Shaw Cablesystems GP 630 - 3rd Avenue SW Calgary, Alberta, Canada T2P 4L4 (403) 781-4948 -Original Message- From: Bryan Gintz [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:39 AM To: PHP List Subject: [PHP] Tables Loading Slow Hi. I have a large database query that returns anywhere from 10-30ish records. The problem comes from loading them in tables. With IE5 and Netscape 5 on windows, the results do not display until the last /table tag is written. Does anyone have any ideas on how to show the results as the come from the query? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Tables Loading Slow
from the PHP manual [flush()] ...Even the browser may buffer its input before displaying it. Netscape, for example, buffers text until it receives an end-of-line or the beginning of a tag, and it won't render tables until the /table tag of the outermost table is seen... even if you're flushing the buffer after rows are processed, you probably wont get any increase in load time because of this rendering issue... it's just a drawback of using tables in html, regardless of how they are generated... -- Adam Leckron [[ [EMAIL PROTECTED] ]] Tony Bibbs [EMAIL PROTECTED] wrote in message 1012401977.6913.10.camel@tbibbs">news:1012401977.6913.10.camel@tbibbs... Check the PHP manual on flush() --Tony On Wed, 2002-01-30 at 08:38, Bryan Gintz wrote: Hi. I have a large database query that returns anywhere from 10-30ish records. The problem comes from loading them in tables. With IE5 and Netscape 5 on windows, the results do not display until the last /table tag is written. Does anyone have any ideas on how to show the results as the come from the query? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Tony Bibbs | Life is a moderately good play [EMAIL PROTECTED] | with a bad 3rd act. 515.554.8046 | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Tables Loading Slow
Maybe this is a solution for you: instead of: table trtd1/tdtddata 1/td/tr trtd2/tdtddata 2/td/tr trtd3/tdtddata 3/td/tr trtd4/tdtddata 4/td/tr /table you can do this: table trtd1/tdtddata 1/td/tr /tablebr table trtd2/tdtddata 2/td/tr /tablebr table trtd3/tdtddata 3/td/tr /tablebr table trtd4/tdtddata 4/td/tr /tablebr If you can't beat them, join them! Greets, Edward Adam Leckron [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... from the PHP manual [flush()] ...Even the browser may buffer its input before displaying it. Netscape, for example, buffers text until it receives an end-of-line or the beginning of a tag, and it won't render tables until the /table tag of the outermost table is seen... even if you're flushing the buffer after rows are processed, you probably wont get any increase in load time because of this rendering issue... it's just a drawback of using tables in html, regardless of how they are generated... -- Adam Leckron [[ [EMAIL PROTECTED] ]] Tony Bibbs [EMAIL PROTECTED] wrote in message 1012401977.6913.10.camel@tbibbs">news:1012401977.6913.10.camel@tbibbs... Check the PHP manual on flush() --Tony On Wed, 2002-01-30 at 08:38, Bryan Gintz wrote: Hi. I have a large database query that returns anywhere from 10-30ish records. The problem comes from loading them in tables. With IE5 and Netscape 5 on windows, the results do not display until the last /table tag is written. Does anyone have any ideas on how to show the results as the come from the query? Thanks. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Tony Bibbs | Life is a moderately good play [EMAIL PROTECTED] | with a bad 3rd act. 515.554.8046 | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Tables Loading Slow
Either have 1 table per row, which means each row will display as it loads, rather than waiting for the other 30 or so. Alternatively, you could break it into chunks of 10, or 5 or whatever. I'm using both these methods on a few sites, with no problems. Justin French -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]