Re: [PHP-DB] mysql -- Commercial DBs, When will I need to upgrade?
Some people in the APC mailing list have said that mysql blows up at around 200-300 queries a second. http://lists.communityconnect.com/pipermail/apc-cache/2001-April/000611.html Phil Jackson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Some good advice already given, and I quite agree. MySQL is no light-weight - comparable to MS SQLServer and Oracle in performance. Also, running the DB on a dedicated DB server may buy some performance. If you must check out SQLServer, then http://www.sqlteam.com is a good place to start. At work we are an ASP shop, and have used Access for some lightweight apps, but the mandate now is to use IBM's DB2 UDB product - a DB2 database server, also, a mainframe IBM OS-390 DB2 database. Don't know the price tag, but they are very robust databases, if a bit quirky getting Microsoft stuff to talk to IBM stuff... You could connect via the ODBC functions of PHP. Also try looking at http://www.4guysfromrolla.com and http://www.asptoday.com - not trying to sell ASP - just good and varied resources with good articles about databases in general can be found there in addition to asp material... Phil J. Doug Schasteen wrote: I've been programming PHP w/ mysql for almost 2 years now for my company. We develop online testing and surveying software. We are currently running operations for a few specific companies where maybe 20-30 tests will be taken online per day (it requires pulling the test questions out of the database in random order, and then putting all of their answers into the database at the end of the test.) This is currently running on a shared webserver using php3 and mysql. Recently we've been talking about some projects that will require a lot more use. (Could be 100 people taking a test at once or it could be 1000 people taking a test at once. We don't know yet.) If anyone has had some experience with upgrading as your operations grow, I'd appreciate if you could answer ANY of the following questions: 1. At what point will mysql blow up (how many tests could be taken at once? How many rows of results could be stored in a table before it bogs down?) 2. At what point will we need a dedicated server instead of shared-hosting? 3. How fast of a server do we need? Will a 1ghz server outperform a 500mhz server when using apache-php-mysql? 4. If we need a new database, what is the next step above mysql? I have some experience with Oracle but it is too expensive. Is there anything inbetween that is friendly to PHP? 5. If MS-SQL is an option for a database-upgrade. What are the implications of switching our server to a win32-based server? Will we have problems with PHP on windows when all of our scripts were programmed for unix? I realize these are a lot of questions and that we probably need some consulting work done, but if any of you could share your knowledge on any one of those topics I would really appreciate it. I just need something to give me a head start in my research. Point me in the right direction! - Doug Schasteen [EMAIL PROTECTED] P.S. - if you know of any good articles online that compare different servers or databases please share. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql -- Commercial DBs, When will I need to upgrade?
Some good advice already given, and I quite agree. MySQL is no light-weight - comparable to MS SQLServer and Oracle in performance. Also, running the DB on a dedicated DB server may buy some performance. If you must check out SQLServer, then http://www.sqlteam.com is a good place to start. At work we are an ASP shop, and have used Access for some lightweight apps, but the mandate now is to use IBM's DB2 UDB product - a DB2 database server, also, a mainframe IBM OS-390 DB2 database. Don't know the price tag, but they are very robust databases, if a bit quirky getting Microsoft stuff to talk to IBM stuff... You could connect via the ODBC functions of PHP. Also try looking at http://www.4guysfromrolla.com and http://www.asptoday.com - not trying to sell ASP - just good and varied resources with good articles about databases in general can be found there in addition to asp material... Phil J. Doug Schasteen wrote: I've been programming PHP w/ mysql for almost 2 years now for my company. We develop online testing and surveying software. We are currently running operations for a few specific companies where maybe 20-30 tests will be taken online per day (it requires pulling the test questions out of the database in random order, and then putting all of their answers into the database at the end of the test.) This is currently running on a shared webserver using php3 and mysql. Recently we've been talking about some projects that will require a lot more use. (Could be 100 people taking a test at once or it could be 1000 people taking a test at once. We don't know yet.) If anyone has had some experience with upgrading as your operations grow, I'd appreciate if you could answer ANY of the following questions: 1. At what point will mysql blow up (how many tests could be taken at once? How many rows of results could be stored in a table before it bogs down?) 2. At what point will we need a dedicated server instead of shared-hosting? 3. How fast of a server do we need? Will a 1ghz server outperform a 500mhz server when using apache-php-mysql? 4. If we need a new database, what is the next step above mysql? I have some experience with Oracle but it is too expensive. Is there anything inbetween that is friendly to PHP? 5. If MS-SQL is an option for a database-upgrade. What are the implications of switching our server to a win32-based server? Will we have problems with PHP on windows when all of our scripts were programmed for unix? I realize these are a lot of questions and that we probably need some consulting work done, but if any of you could share your knowledge on any one of those topics I would really appreciate it. I just need something to give me a head start in my research. Point me in the right direction! - Doug Schasteen [EMAIL PROTECTED] P.S. - if you know of any good articles online that compare different servers or databases please share. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql -- Commercial DBs, When will I need to upgrade?
Your DB needs sound more hardware intensive than anything. Your queries sound simple and I would bet you would never need to use anything but mysql. Also keep in mind that mysql/php/apache etc run on more than just PC's. There is some serious hardware out there that can handle unbelieveable amounts of trafficof course non of it is intel based :) If an Intel box can no longer handle the load, you can split your servers so you have one running a web server and another handling the DB, or simply move to some real hardware. (ie HP/Sun/IBM unix boxes). Larry H. Doug Schasteen wrote: I've been programming PHP w/ mysql for almost 2 years now for my company. We develop online testing and surveying software. We are currently running operations for a few specific companies where maybe 20-30 tests will be taken online per day (it requires pulling the test questions out of the database in random order, and then putting all of their answers into the database at the end of the test.) This is currently running on a shared webserver using php3 and mysql. Recently we've been talking about some projects that will require a lot more use. (Could be 100 people taking a test at once or it could be 1000 people taking a test at once. We don't know yet.) If anyone has had some experience with upgrading as your operations grow, I'd appreciate if you could answer ANY of the following questions: 1. At what point will mysql blow up (how many tests could be taken at once? How many rows of results could be stored in a table before it bogs down?) 2. At what point will we need a dedicated server instead of shared-hosting? 3. How fast of a server do we need? Will a 1ghz server outperform a 500mhz server when using apache-php-mysql? 4. If we need a new database, what is the next step above mysql? I have some experience with Oracle but it is too expensive. Is there anything inbetween that is friendly to PHP? 5. If MS-SQL is an option for a database-upgrade. What are the implications of switching our server to a win32-based server? Will we have problems with PHP on windows when all of our scripts were programmed for unix? I realize these are a lot of questions and that we probably need some consulting work done, but if any of you could share your knowledge on any one of those topics I would really appreciate it. I just need something to give me a head start in my research. Point me in the right direction! - Doug Schasteen [EMAIL PROTECTED] P.S. - if you know of any good articles online that compare different servers or databases please share. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] mysql -- Commercial DBs, When will I need to upgrade?
If anyone has had some experience with upgrading as your operations grow, I'd appreciate if you could answer ANY of the following questions: Did you say M$.. yuck.. if you think you need something else then MySQL you could take a look at PostgreSQL.. It's good, it's free and it doesn't have M$ written all over it :-) The subject sounds like commercial databases are better then OpenSource.. I don't think that's treu. You could find great solutions in OpenSource.. Like MySQL.. PostgreSQL and others.. I even know quite a few people on several lists who kicked off commercial products and started using opensource.. for various reasons. If you look at the specs.. you will see MySQL performs very good.. also with large databases. Having your own dedicated server will help you to get better performing websites.. Memory.. the more.. the better.. you can have to little but never to much of it.. If you're currently experiencing performance problems I would assume a dedicated server might help.. Bye, B. P.S. the subject is great flamebait.. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]