AJAX Forums

what database should I choose for scaling a

This is a discussion on what database should I choose for scaling a within the Web 2.0 forums, part of the General category; web 2.0 application? 10 million users - mostly select on tables.? i am using PHP on Linux redhat and Apache. Considering continuing with MySQL, or move to Oracle...


Go Back   AJAX Forums > General > Web 2.0

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
Old 03-18-2007, 09:43 AM   #1 (permalink)
Junior Member
 
Join Date: Mar 2007
Posts: 1
Rep Power: 0 Saar M is on a distinguished road
what database should I choose for scaling a

web 2.0 application? 10 million users - mostly select on tables.? i am using PHP on Linux redhat and Apache. Considering continuing with MySQL, or move to Oracle
__________________
<a href="http://developer.yahoo.com/about"><img src="http://us.dev1.yimg.com/us.yimg.com/i/us/nt/bdg/websrv_120_1.gif" border="0"> </a>
Saar M is offline   Reply With Quote
Old 03-18-2007, 05:12 PM   #2 (permalink)
Junior Member
 
Join Date: Mar 2007
Posts: 1
Rep Power: 0 Linux OS is on a distinguished road
MySQL or Postgres will do just fine.
__________________
<a href="http://developer.yahoo.com/about"><img src="http://us.dev1.yimg.com/us.yimg.com/i/us/nt/bdg/websrv_120_1.gif" border="0"> </a>
Linux OS is offline   Reply With Quote
Old 03-19-2007, 06:54 AM   #3 (permalink)
Junior Member
 
Join Date: Mar 2007
Posts: 1
Rep Power: 0 John Q is on a distinguished road
Follow the rest of the LAMP architecture and go with mysql. Look into which internal tweaks and dbs to maximize performance ie innodb vs any other, based on how it will be used mostly (transactional, read-only etc). You are going open source with L)inux A)pache M)ySQL and P)hp. With Oracle you would be spending some serious money. Stick with the freebies and twink it based on how it will be used.
__________________
<a href="http://developer.yahoo.com/about"><img src="http://us.dev1.yimg.com/us.yimg.com/i/us/nt/bdg/websrv_120_1.gif" border="0"> </a>
John Q is offline   Reply With Quote
Reply

Bookmarks


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

 
Thread Tools
Display Modes


Similar Threads

Thread Thread Starter Forum Replies Last Post
Scaling Web Apps to Meet the iPhone Challenge microbee AJAX Help 0 09-30-2008 07:33 AM
Which RIA Platform To Choose? microbee AJAX Help 0 02-13-2008 12:14 AM
AJAX Tookits, Frameworks and IDEs: How Do You Choose the Right One? microbee AJAX Help 0 01-09-2008 03:01 PM
AJAXWorld - Webtide Explores Scaling AJAX Without Breaking the Bank microbee AJAX Help 0 10-01-2007 10:05 AM
AJAX, Flash, Silverlight, or JavaFX: Must We Choose? microbee AJAX Help 0 08-17-2007 07:01 PM


All times are GMT -4. The time now is 04:55 PM.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 RC5
Copyright ©2006 - 2008, AJAXwith.com