Working with large MySQL databases

etrader · 10-18-2007, 10:19 AM

It is evident that when MySQL database is large, it will significantly reduce the load speed of the site.

However, thesedays there several big sites using MySQL server to store their data, I am curious how they can provide fast services?

What is the common tricks for working with large databases ?

hasan_889 · 10-18-2007, 04:17 PM

Quote:

Originally Posted by etrader

It is evident that when MySQL database is large, it will significantly reduce the load speed of the site.

Any proof for your statement?

etrader · 10-19-2007, 03:25 AM

proof of which part ? that famous sites have large databases ? or the fact that large databases will reduce the site speed ?

pelinga · 11-09-2007, 05:57 AM

first of all , mysql is not for big database ... there are MSsql and better Oracle

second you have to create index for a lot of fields to improve you DB speed

also be carefully with the connections( Open and close)

Intripita-MH · 11-11-2007, 03:24 AM

Oracle works well for large enterprise-sized databases.

Another option is to divi the databases up into different servers. Google has hundreds, for example, most of which store data, and the rest store indexes to that data to be referenced. (From what I understand.) Search queries reference the indexes and access the actual storage on a certain server within half a second because, well, Google rocks that way.

I doubt you'll be getting into stuff that big, ... but MySQL is good for relational-type stuff, as long as it doesn't get too large...

Also, it is true that larger databases induce slower load times. More data to parse takes longer. Most of the time it's not noticeable, until you get lots of load and lots of data.

10-18-2007, 10:19 AM	#1
etrader Member Join Date: Feb 2007 Posts: 134	Working with large MySQL databases It is evident that when MySQL database is large, it will significantly reduce the load speed of the site. However, thesedays there several big sites using MySQL server to store their data, I am curious how they can provide fast services? What is the common tricks for working with large databases ? __________________ http://wikipersona.org http://besttorontocondo.com

10-19-2007, 03:25 AM	#3
etrader Member Join Date: Feb 2007 Posts: 134	Re: Working with large MySQL databases proof of which part ? that famous sites have large databases ? or the fact that large databases will reduce the site speed ? __________________ http://wikipersona.org http://besttorontocondo.com

11-09-2007, 05:57 AM	#4
pelinga Member Join Date: May 2007 Posts: 125	Re: Working with large MySQL databases first of all , mysql is not for big database ... there are MSsql and better Oracle second you have to create index for a lot of fields to improve you DB speed also be carefully with the connections( Open and close) __________________ Lisisoft::Panload::About-Recipes Calculate Page Rank

11-11-2007, 03:24 AM	#5
Intripita-MH Senior Member Join Date: Sep 2006 Posts: 280	Re: Working with large MySQL databases Oracle works well for large enterprise-sized databases. Another option is to divi the databases up into different servers. Google has hundreds, for example, most of which store data, and the rest store indexes to that data to be referenced. (From what I understand.) Search queries reference the indexes and access the actual storage on a certain server within half a second because, well, Google rocks that way. I doubt you'll be getting into stuff that big, ... but MySQL is good for relational-type stuff, as long as it doesn't get too large... Also, it is true that larger databases induce slower load times. More data to parse takes longer. Most of the time it's not noticeable, until you get lots of load and lots of data. __________________ Intripita :: web hosting \| development \| conferencing Business-Grade Web Hosting, Professional Conferencing, Effective Web Development by Intripita

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hostings with good MySQL databases	etrader	Web Hosting	10	11-12-2007 11:08 AM
Interested in LARGE investment?	Katey	General Talk	9	04-12-2007 10:36 PM
Merge Two MySql databases	yalla	MySQL	5	04-06-2007 04:00 PM
Website Content Databases - MySQL & MS Access	odditysoftware	Websites for Sale	115	11-28-2006 08:19 PM
How to sell a large site	DocSharpe	Websites for Sale	1	09-12-2006 02:29 PM