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 4 1808
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.btint ernet.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
"alex" <no****@nospam. com> wrote in message
news:ck******** **@sparta.btint ernet.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.
"alex" <no****@nospam. com> wrote in message
news:ck******** **@sparta.btint ernet.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.
Thanks for the help everyone. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: francescomoi |
last post by:
Hi.
I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2:
----------------------------------
# export PATH=$PATH:/usr/local/mysql/bin/
# export mysqlclient=mysqlclient_r
# python setup.py clean
# python setup.py build
running build
running build_py
|
by: mikey |
last post by:
Hi all,
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.
There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I can not seem to get any of the functions
working on it. So I have now dopwnloaded the latest version hoping
that this will fix the error.
I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but
|
by: Yun Guan |
last post by:
Hello mysql gurus,
I am trying to run perl on mysql database on Red Hat box. I want to install
DBI and DBD:mysql using CPAN:
perl -MCPAN -e shell
cpan>install DBI
The above succeeded, but
cpan>install DBD::mysql
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest version of this document can be found at:
http://prdownloads.sourceforge.net/souptonuts/README_mysql.txt?download
|
by: Saqib Ali |
last post by:
I installed mySQL and have it running.... but I think I made a
mistake somewhere along the line...... I believe I did follow the
instructions that were provided with the distribution at:
http://dev.mysql.com/downloads/
The database is up. It seems that a test database
instance has been created (named "test"). I can see
it. However, the other database instance that should
have been created, named "mysql" doesn't show up when
I do "show...
| |
by: Alex Hunsley |
last post by:
I am trying to install the DBD::mysql perl module. However, it claims I
need mysql.h:
cpan> install DBD::mysql
CPAN: Storable loaded ok
Going to read /home/alex/.cpan/Metadata
Database was generated on Mon, 29 Nov 2004 16:01:05 GMT
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9004.tar.gz
CPAN: Digest::MD5 loaded ok
|
by: ./Rob & |
last post by:
Hi gang:
I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0
to 4.1.10 and now when I login as root it doesn't show all the databases I
should have access to, nor it doesn't recognize me being logged in as root
(via CURRENT_USER().)
Here it is, line-by-line. Inline comments are denoted by '//'
|
by: trihanhcie |
last post by:
I m currently working on a Unix server with a fedora 3 as an os
My current version of mysql is 3.23.58. I'd like to upgrade the version
to 5.0.18.
After downloading from MYSQL.COM the package on the site, I made :
rpm -i MySQL-server-5.0.18-0.i386.rpm
then i have errors that relate to many conflicts. I cannot figure out
why -and- cannot upgrade. Please Help !
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
warning: MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
file /etc/my.cnf from install of MySQL-server-standard-5.0.24a-0.rhel3 conflicts with file from package mysql-3.23.58-1
file...
|
by: menzies |
last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a successful 'sudo make install.' Before every attempt I even do a sudo make distclean to make sure I haven't gotten things mucked up from a prior attempt.
OS: Mac OS X 10.4.10
MySQL: v5.0.41 for Mac OSX-i686
DBI: v1.58 (installed fine using CPAN)...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |