Posted by J.O. Aho on 10/13/65 11:43

strawberry wrote:
> Thanks for the input. From what you say, it seems like I'm doing things
> OK. I tried removing all the 'echoes' but couldn't detect any
> difference to performance - no better, no worse.

On a somewhat normal machine you won't detect the difference, it's somewhere
near 0.03s for a 1000 line of HTML, if you go and use an i286 then you may
notice it a lot more.


> Unfortunately, I'm coming to the conclusion that my machine is simply
> rather slow. :-(

What spec does you machine have?
Do you run the sql server on the same machine?
Do you use a load of joins in your sql-statements?
Do you have network related troubles on your machine if you use say links,
ncftp, micq on it?


> One thing though; you're post implies that you actively close the
> connection - something that my script doesn't do (I thought it closed
> automatically upon execution of the script).
> Does is make a difference if I close it or not?

If you use mysql_connect() and you don't close the connection, the connection
will be automatically ended when the script ends, but it's good habit to do it
yourself, this lessens the risk that you ignore to close filestreams.


//Aho

[Back to original message]