Turning to you for help in a speed matter
Posted: Wed Feb 11, 2004 8:56 am
Hi there,
I am running php 4.2.2 on an HP-UX server along side with MySql 3.23.42 and apache 1.3.27 and these are pretty much rock solid for me.
But, I'm having a bit of a performance issue and was hoping that you guys & girls can help me out.
I have a table that is about 9000 records and grows at the rate of a few hundred a day (so it aint large by any means!) but what is really painful is dumping this data into an HTML table and then showing it to a user. I have looked at what is happinging within my code and can see that I'm going to the database for each and every record and I can see that this is taking a long time to do, so what is the best method of retrieving large(ish) amounts of data from a database and dumping it into a tabl
e?
Thanks for reading and maybe jotting down a clue or two
Mark
I am running php 4.2.2 on an HP-UX server along side with MySql 3.23.42 and apache 1.3.27 and these are pretty much rock solid for me.
But, I'm having a bit of a performance issue and was hoping that you guys & girls can help me out.
I have a table that is about 9000 records and grows at the rate of a few hundred a day (so it aint large by any means!) but what is really painful is dumping this data into an HTML table and then showing it to a user. I have looked at what is happinging within my code and can see that I'm going to the database for each and every record and I can see that this is taking a long time to do, so what is the best method of retrieving large(ish) amounts of data from a database and dumping it into a tabl
e?
Thanks for reading and maybe jotting down a clue or two
Mark