Re: Giant database vs unlimited databases

2007-11-20 Thread Eric Frazier
Russell E Glaue wrote: No one probably wants to go through the trouble to code this solution but it is possible to use MySQL Proxy to filter the SQL statements and results. MySQL Proxy sits in between MySQL Server and the MySQL Client. It can read queries, modify them, send queries to the se

Re: Giant database vs unlimited databases

2007-11-20 Thread Russell E Glaue
t; separate DBs. > > Thanks for the Oracle lesson :) > > Thanks, > > Eric > > > > > > > > >> - Original Message >> From: Eric Frazier <[EMAIL PROTECTED]> >> To: Mohammad wrk <[EMAIL PROTECTED]> >> C

Re: Giant database vs unlimited databases

2007-11-20 Thread Eric Frazier
Thanks for the Oracle lesson :) Thanks, Eric - Original Message From: Eric Frazier <[EMAIL PROTECTED]> To: Mohammad wrk <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Monday, November 19, 2007 7:42:13 AM Subject: Re: Giant database vs unlimited databases Mohamma

Re: Giant database vs unlimited databases

2007-11-19 Thread Mohammad wrk
; Cc: mysql@lists.mysql.com Sent: Monday, November 19, 2007 7:42:13 AM Subject: Re: Giant database vs unlimited databases Mohammad wrk wrote: > Hi, > > I'm working on a web 2.0 project that targeting small to medium size > companies for providing business services. Companies si

Re: Giant database vs unlimited databases

2007-11-19 Thread Eric Frazier
Mohammad wrk wrote: Hi, I'm working on a web 2.0 project that targeting small to medium size companies for providing business services. Companies simply register to the site and then start their business by loading their data, sharing and discussing them with others. The design/architectural

Re: Giant database vs unlimited databases

2007-11-19 Thread Russell E Glaue
How much power do you want? We migrated from Oracle to MySQL because to get enough power from Oracle 8/9i, we had to buy an extremely powerful machine. We had oracle on a sun solaris 9 box, and got X amount of power out of it. On a similar machine we installed MySQL and we got XX amount of power

Re: Giant database vs unlimited databases

2007-11-19 Thread David T. Ashley
On 11/19/07, Mohammad wrk <[EMAIL PROTECTED]> wrote: > > Hi, > > I'm working on a web 2.0 project that targeting small to medium size > companies for providing business services. Companies simply register to the > site and then start their business by loading their data, sharing and > discussing th

RE: Giant database vs unlimited databases

2007-11-19 Thread Jay Blanchard
[snip] The justification for the latter is that MySQL is not powerful enough (compare to Oracle or DB2) to handle large amount of data and concurrent users. [/snip] Not true and it has been proven time and again by the likes of Yahoo and others that size. We routinely use MySQL for large data stor