Re: [PHP] Code Improvement

2002-06-13 Thread Miguel Cruz
On Thu, 13 Jun 2002, Pong-TC wrote: > I run the simple code to display data from the database. There are around > 5000 records and 50 fields. It takes around 1 1/2 min to retrieve the > data to the browser. I'd like to know if we can improve my code. So, I > can retrieve the data in a shorter

Re: [PHP] Code Improvement

2002-06-13 Thread Kevin Stone
Though your code isn't the cleanest I've seen I don't think there is anything inherently wrong with your proceedure. You're just displaying a LOT of information. And more importantly you're displaying this in a browser with HTML tables. I'd put a timer on your code to see how much time the actu

RE: [PHP] Code Improvement

2002-06-13 Thread Lazor, Ed
Why display all 5000 records and 50 fields at once? Typically, you display a sub-set of the row data and page through it to improve performance. Also, you typically display a sub-set of fields and then view individual records for full detail. > -Original Message- > From: Pong-TC [mailto