From: Mark Unwin Date: August 15 2005 11:13pm Subject: Slashdot Article - Improving Database Performance List-Archive: http://lists.mysql.com/ug-brisbane/16 Message-Id: <3DAF0884F22B6E43954EED83F4ACCD0104B90640@qpcu-svr3.ho.qpcu.org.au> X-MS-Has-Attach: X-MS-TNEF-Correlator: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable An anonymous reader asks: "An acquaintance of mine runs a fair sized web community. Having nearly 280,000 users in a single MySQL database with about 12 mirrors accessing it, performance has become an big issue. I was wondering what practical methods could be used to lessen the load and decrease user query times. Funds are limited, so he'd rather not pay for a commercial database system at this time." http://ask.slashdot.org/article.pl?sid=3D05/08/15/2117229&tid=3D221&tid=3D1= 98& tid=3D4 Mark Unwin. ***************************************************************************= ********************** This message and any attachments, or any part of it is intended solely for the named addressee. =20 Reading, printing, distribution, storing, commercialising or acting on this transmission or any information it contains, by anyone ot= her than the addressee, is prohibited. If you have received this message in= error, please destroy all copies and notify=20 Qld Police Credit Union Ltd on +61 7 3008 4444 or by replying to the sender. This message may contain legally privileged and confidential information, and/or copyright material of QPCU or third parties. QPCU is not responsible for any changes made to a document other than those made by QPCU, or for the effect of the changes on the document's meaning. You should only re-transmit, distribute or commercialise the material if you are authorised to do so. Any views expressed in this message are those of the individual sender. You may not rely on this message as advice= unless subsequently confirmed by fax or letter signed by an Officer or Dir= ector of QPCU, or=20 an Authorised Representative QPCU. QPCU advises that this e-mail and any attached files should be scanned to d= etect viruses. QPCU accepts no liability for loss or damage (whether cause= d by negligence or not) resulting from the use of any attached files. Information regarding Privacy can be found at the QPCU web site. ( www.qpcu= .org.au ) General Advice Warning Any advice has been prepared without taking into account your particular ob= jectives, financial situation or needs. For that reason, before acting on = the advice you should consider the appropriateness of the advice having reg= ard to your own objectives, financial situation and needs. Where the advic= e relates to the acquisition, or possible acquisition, of a particular fina= ncial product, you should obtain a Product Disclosure Statement relating to= the product and consider the Product Disclosure Statement before making an= y decision about whether to acquire the product. ***************************************************************************= **********************