Would a medium sized (~500 pages) database driven website, search
engine and mailing list be too much for one MySQL database? Instead of
making using different databases I would use different tables. I would
use PHP for all of this.
Any help would be greatly appreciated. 7 1928
Peter Bach wrote: Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated.
that will depend on the OS and hardware involved and the number of
anticipated hits. for maybe a few hundred hits a week it might not be
too bad, but if your talking many hits per minute, then you might want
to use something better. MySQL was designed to used in small-ish
environments, but some people seem to push whatever technology to the
edge of the envelope. Try to ensure that your database "doesn't
matter". And by that I mean that you will be able to move it to a more
enterprise-class database engine if need be (I currently do not consider
SQL Server to be "Enterprise " class, although there are those who would
disagree with me :)....
Michael Austin
DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS).
Peter Bach wrote: Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated.
Not according to the mysql documentation, it wouldn't: 'Handles large
databases. We use MySQL Server with databases that contain 50 million
records. We also know of users who use MySQL Server with 60,000 tables
and about 5,000,000,000 rows.'
HTH,
Margaret
--
(To mail me, please change .not.invalid to .net, first.
Apologies for the inconvenience.)
In message <qp************ *************** *****@4ax.com>, Margaret
MacDonald <sc**********@a tt.not.invalid> writes Peter Bach wrote:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated. Not according to the mysql documentation, it wouldn't: 'Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.'
Not much help without knowing what the load is, IMHO. HTH, Margaret
--
Five Cats
Email to: cats_spam at uk2 dot net
"Five Cats" <ca*******@[127.0.0.1]> wrote in message
news:bQ******** ******@[127.0.0.1]... In message <qp************ *************** *****@4ax.com>, Margaret MacDonald <sc**********@a tt.not.invalid> writesPeter Bach wrote:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated.
Not according to the mysql documentation, it wouldn't: 'Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows.'
Not much help without knowing what the load is, IMHO.
HTH, Margaret
The OP hasn't even mentioned the rate of potential hits, just the size of
the data. To which the answer is "yes, easily". Access speed is a function
of hardware, table design and the ability of the database drivers to handle
multiple concurrent requests. Any shortcoming of those three will drop you
in it; I don't believe MySQL will be the weak link.
Chances are, if the OP is asking about design questions on Usenet, s/he's
not going to be in charge of a project where hit rate is going to be an
issue. No offence. 8)
Garp
I use Intel servers with Dual Xeon processors and Linux/Red Hat &
Apache. A "few hundred hits a week" is probably all I'll get. But
traffic may increase...
Michael Austin <ma*****@firstd basource.com> wrote in message news:<Pn******* **********@news svr22.news.prod igy.com>... Peter Bach wrote:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated.
that will depend on the OS and hardware involved and the number of anticipated hits. for maybe a few hundred hits a week it might not be too bad, but if your talking many hits per minute, then you might want to use something better. MySQL was designed to used in small-ish environments, but some people seem to push whatever technology to the edge of the envelope. Try to ensure that your database "doesn't matter". And by that I mean that you will be able to move it to a more enterprise-class database engine if need be (I currently do not consider SQL Server to be "Enterprise " class, although there are those who would disagree with me :)....
Michael Austin DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS).
"Garp" <ga***@no7.blue yonder.co.uk> wrote in message
news:MX******** *************@n ews-text.cableinet. net... The OP hasn't even mentioned the rate of potential hits, just the size of the data. To which the answer is "yes, easily". Access speed is a function of hardware, table design and the ability of the database drivers to
handle multiple concurrent requests. Any shortcoming of those three will drop you in it; I don't believe MySQL will be the weak link.
Not that having multiple databases would have any material affect on server
load. We are still dealing with the same amount of data regardless of how
you divide it up.
MySQL will quite easily handle this. In any case this could be
considered over-kill. SQLite could even handle this.
Grant
Peter Bach wrote: I use Intel servers with Dual Xeon processors and Linux/Red Hat & Apache. A "few hundred hits a week" is probably all I'll get. But traffic may increase...
Michael Austin <ma*****@firstd basource.com> wrote in message news:<Pn******* **********@news svr22.news.prod igy.com>...
Peter Bach wrote:
Would a medium sized (~500 pages) database driven website, search engine and mailing list be too much for one MySQL database? Instead of making using different databases I would use different tables. I would use PHP for all of this.
Any help would be greatly appreciated.
that will depend on the OS and hardware involved and the number of anticipated hits. for maybe a few hundred hits a week it might not be too bad, but if your talking many hits per minute, then you might want to use something better. MySQL was designed to used in small-ish environment s, but some people seem to push whatever technology to the edge of the envelope. Try to ensure that your database "doesn't matter". And by that I mean that you will be able to move it to a more enterprise-class database engine if need be (I currently do not consider SQL Server to be "Enterprise " class, although there are those who would disagree with me :)....
Michael Austin DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS). This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Bruce A. Julseth |
last post by:
When I execute this SQL statement in my PHP code, I get an error
"File '.\Address.txt' not found (Errcode: 2)"
$File = addslashes(".\Address.txt");
$SQL = "Load Data InFile \"" . $File . "\" into table addresses";
$result = mysql_query($SQL) or die(mysql_error());
The file is located in the same directory as my .PHP file.
How do I generate a relative address for this file so that it can be found?
|
by: phpnube |
last post by:
I used this php package to install on my system... (i had problems with the
isapi package from php so im back to the cgi portion of PHP php-cgi.exe)
PHP 5.0.0 installer - 26 July 2004
(CGI only, packaged as Windows installer to install and configure PHP, and
automatically configure IIS, PWS and Xitami, with manual configuration for
other servers. N.B. no external extensions included
It works fine... as the test page outputs the...
|
by: Michael Weiner |
last post by:
I know this is quite a bit off topic, but i was wondering if anyone else
out there had any experience with Segue's Silk Performer load testing
tools. More specifically, i am trying to compile a test script to allow
me to perform some transactional database testing to load test a MySQL
4.0.13 database server running behind some apache webservers. I have
obtained an ODBC driver from MySQL and have some specific queries i
would like to use in...
|
by: Lenz Grimmer |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
MySQL 4.0.14, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary form
for a number of platforms from our download pages at
http://www.mysql.com/downloads/ and mirror sites.
|
by: Donald Tyler |
last post by:
Then the only way you can do it that I can think of is to write a PHP script
to do basically what PHPMyAdmin is trying to do but without the LOCAL in
there.
However to do that you would need to be able to place the PHP file on the
server, and I guess you probably can't do that either. Talk about catch
22...
The only other way I can think of is to install MySQL on a machine you
control, then import the data there using the method I...
| |
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally. The network
connection is very...
|
by: Mairhtin O'Feannag |
last post by:
Hello,
I have a client (customer) who asked the question : "Why would I buy and
use UDB, when MySql is free?"
I had to say I was stunned. I have no experience with MySql, so I was
left sort of stammering and sputtering, and managed to pull out something
I heard a couple of years back - that there was no real transaction
safety in MySql. In flight transactions could be lost.
|
by: Good Man |
last post by:
Hi there
I've noticed some very weird things happening with my current MySQL setup
on my XP Laptop, a development machine.
For a while, I have been trying to get the MySQL cache to work. Despite
entering the required lines to "my.ini" (the new my.cnf) through notepad
AND MySQL Administrator, the cache does not work.
So, today I took a peek at the 'Health' tab in MySQL Administrator.
|
by: edfialk |
last post by:
Hi all, I'm desperately trying to get a simple mysql connection
working in php 4.3.9 and I think I have a doozy for you guys. First
of all, I didn't set up ANY of this system, I'm just working with it.
So, on Redhat, we have two versions of PHP - Apache uses 4.3.9,
there's also a 4.4.2 that is default from command-line. 4.3.9 was
installed by RPM, 4.4.2 was built from source.
I can get mysql.so loaded and working fine in 4.4.2, but...
|
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: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
| |
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...
| |