"alex" <no****@nospam.com> wrote in message
news:ck**********@sparta.btinternet.com...
Hi. I am making a page that lots of data on the first page that I want
links displayed in a random order. If lots of people are looking at it, would I
be better using a page that uses arrays and shuffle(), or would I be ok to
use mysql.
You are far better off reading only the records/fields from the database
which you need and in the order you need them than to load the whole lot
into memory and process them there.
SELECT * FROM foo ORDER BY RAND()
If there are over a hundred visitors a day, would mysql be making the site
slow?
If your site content doesn't change much then php/mysql will make the site
slower than having static html pages. However the cost of hardware is
comparitively little compared to the cost of you editing lots of files to
make a style change for instance.
I don't know much about hardware, and if using mysql to get data for a
front page is too much, could it overload mysql?
If your design is bad, and you've got lots of other resource hungry
applications on the server then yes.
Is there any point where it's better to use php to write html rather than
query a database everytime the page loads?
You need the data from somewhere, mysql (a.n.other rdms) happens to be in
most circumstances a lot easier and faster than embeding code into a
specific file. For example you can easily change the contents of the main
page using an CMS user interface rather then editing the file in a HTML
Editor and then uploading that file using FTP.