By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,719 Members | 1,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,719 IT Pros & Developers. It's quick & easy.

php or mysql

P: n/a
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.
If there are over a hundred visitors a day, would mysql be making the site
slow?
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?

Is there any point where it's better to use php to write html rather than
query a database everytime the page loads?

I would be very happy if anyone could explain this, because I could not find
the answer in books or on the web.

Alex
Jul 17 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
100 visitors a day is nothing. Don't worry about it until you get 100
visitors a second.

--
Tony Marston

http://www.tonymarston.net

"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.
If there are over a hundred visitors a day, would mysql be making the site
slow?
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?

Is there any point where it's better to use php to write html rather than
query a database everytime the page loads?

I would be very happy if anyone could explain this, because I could not
find
the answer in books or on the web.

Alex

Jul 17 '05 #2

P: n/a
"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.
Jul 17 '05 #3

P: n/a
"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.
If there are over a hundred visitors a day, would mysql be making the site
slow?
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?

Is there any point where it's better to use php to write html rather than
query a database everytime the page loads?

I would be very happy if anyone could explain this, because I could not find the answer in books or on the web.

Alex


It all depends on how often the data changes. If it changes infrequently,
then it's probably not worth the effort to use a database.
Jul 17 '05 #4

P: n/a
Thanks for the help everyone.
Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.