RE: [PHP-DB] PHP can't lose to Micro$oft - Please HELP!

Is this not the no. 1 general problem being a techie rather than a manager ? I even provided easy-understandable benchmarking tests of specific testcases at my resent employer comparing mySQL vs MSSQL7 and Oracle8i... And they went out approving a costly Oracle license simply because "it was a good word to use in the marketing campaign" *sigh* Needless to say - I am not employee there anymore ... / LJ -----Original Message----- From: Helge A. Kraenz (FF) [mailto:HKraenz@mdli.com] Sent: 11. oktober 2001 15:24 To: 'Jason G.'; Helge A. Kraenz (FF); 'Dave Watkinson'; php-db@lists.php.net Subject: RE: [PHP-DB] PHP can't lose to Micro$oft - Please HELP! This sounds really nice. But there is an another big problem: Can anybody give me a hint how to convince my bosses to replace Oracle with MySQL? They think, everything that costs nothing is worth nothing. Helge > -----Original Message----- > From: Jason G. [mailto:blair@nb.net] > Sent: Donnerstag, 11. Oktober 2001 08:12 > To: Helge A. Kraenz (FF); 'Dave Watkinson'; php-db@lists.php.net > Subject: RE: [PHP-DB] PHP can't lose to Micro$oft - Please HELP! > > > Check this out: > > Currently Mytrix provides extended statistics for more than > 200 000 web > resources, accounting for more than 70 million events per > day. The "raw" > gathered data is stored in a self-implemented data warehouse, and > statistics of it are stored in MySQL databases. > MySQL is used for extensive analysis of the data. For a > couple of years > MyISAM tables were used to store the processed data. We found > that the > InnoDB support for transactions, row level locks, and fast > automatic crash > recovery gives us an advantage, so we are migrating to InnoDB now. > Totally we have about 30 servers (mostly Dual PIII with 1-2 > GB of RAM) > which have in total more than 1 TB of data stored in MySQL > databases. The > number of tables is more than 100 000 (small tables were used > with MyISAM > to overcome concurrency problems in table level locking used > with MyISAM). > The tables contain more than 20 000 000 000 rows in total. > > > At 07:44 AM 10/11/2001 +0200, Helge A. Kraenz (FF) wrote: > >I'm absolutely no fan of commercial software but Oracle > actually has (or has > >had) some advantages compared with MySQL: > >- You can make subqueries, e.g. "select * from ( select * > from table )" > >- You can (not easily, OK) handle LOB with a size up to 2 GB > >- Oracle can handle LARGE databases (>> 10GB >100GB) - I > don't know wheter > >MySQL is able to do this > >Maybe MySQL was improved since the last time I read anything > about these > >features but otherwise if you need any of these features you > cannot use > >MySQL or you have to implement time consuming workarounds. > If you don't rely > >on these features, throw any commercial database away and > use Postgres or > >MySQL. > > > >My strongest suggestion is to drop MS Windows and to move to > Unix/Linux with > >you webserver this saves a lot of money and prevents you > from many crashes - > >I never get my Linux system to crash but my Win2K system > freezes each day > >when I shut it down. > > > >Helge > > > > > -----Original Message----- > > > From: Dave Watkinson [mailto:d.watkinson@mightymatch.com] > > > Sent: Donnerstag, 11. Oktober 2001 07:12 > > > To: php-db@lists.php.net > > > Subject: RE: [PHP-DB] PHP can't lose to Micro$oft - Please HELP! > > > > > > > > > we dropped Oracle Java and IIS for MySQL PHP and Apache. > > > > > > We spent a *hell* of a lot of money that we won't get back > > > (anybody want > > > a second hand Oracle licence!!!), but the systems is > about a million > > > times faster, more efficient, easier to improve, stable, > platform & > > > browser independent than ever before. > > > > > > I say you suggest dropping everything and look at the > situation as a > > > whole - not just cost but also features, ease of use (why > recompile > > > crappy Java Applets every five minutes when you can use > Notepad?!) and > > > evertthing else I listed above. > > > > > > > > > Cheers > > > > > > Dave > > > > > > > > > -----Original Message----- > > > From: Jason G. [mailto:blair@nb.net] > > > Sent: 11 October 2001 06:21 > > > To: Notmy Realname; php-db@lists.php.net > > > Subject: Re: [PHP-DB] PHP can't lose to Micro$oft - Please HELP! > > > > > > > > > I do not know much about informix, but personally, if MySQL or > > > PostgreSQL > > > is better, then who cares how much you spent on informix. > > > Use the best > > > tool for the job! > > > > > > > > > At 10:11 PM 10/10/2001 -0700, Notmy Realname wrote: > > > >Situation: > > > > > > > >Small software company is at a cross-road. Do we use ASP > > > (Win 2k, IIS, > > > >VB...) or PHP (UNIX, Apache...). Currently we have two teams > > > working on > > > >prototypes for this project. The Micro$oft pets (ASP) vs. the PHP > > > >free-spirits (btw, PHP is way ahead in features > > > implemented!). Good vs. > > > >Evil, right? :) > > > > > > > >Anyway, THE PROBLEM: > > > > > > > >We use INFORMIX IDS 7.3 (Windows) for db. Can't change > that (spent to > > > much > > > >money on it). The problem we are having is this: > > > > > > > >We create a persistent connection with the Informix server: > > > > > > > > $database = "tst22"; > > > > $server = "some_db_server"; > > > > $login = "blah"; > > > > $password = "blabblah"; > > > > > > > > $dbs = $database."@".$server; > > > > > > > > $connect_id_roll = > ifx_pconnect($dbs,$login,$password); <-- > > > Line > > > >51 --| > > > > > > > > if (!$connect_id_roll) { > > > > echo "Unable to connect to Informix database<br>\n"; > > > > chk_ifx_err1($connect_id_roll); > > > > } > > > > ... (our code) > > > > > > > >This works fine; most of the time that is, until we get this > > > (somewhat > > > >randomly): > > > > > > > >Warning: E [SQLSTATE=08 002 SQLCODE=-1802] in > > > >d:\apache_webdocs\php_demo\roll_list.php on line 51 > > > >Unable to connect to Informix database > > > > > > > >Informix error: E [SQLSTATE=08 002 SQLCODE=-1802] > > > > > > > >Connection name in use. > > > > > > > >The ifx_error function return the following string: > > > > > > > >x [SQLSTATE = aa bbb SQLCODE=cccc] > > > > > > > >where x = space : no error > > > >E : error > > > >N : no more data > > > >W : warning > > > >? : undefined > > > >W : warning > > > > > > > >So, until we fix this problem we can't proceed to develop > > > the reset of > > > the > > > >application the boss says, which is quite understandable, > > > and of course > > > the > > > >other team is closing in (although buggy as hell) we > can't afford to > > > let the > > > >Micro$oft script kitties win this one, can we?! Please help. > > > > > > > >Thanks in advance, > > > > > > > >Anonymouse Self > > > > > > > > > > > > > > > >-- > > > >PHP Database Mailing List (http://www.php.net/) > > > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > >For additional commands, e-mail: php-db-help@lists.php.net > > > >To contact the list administrators, e-mail: > > > php-list-admin@lists.php.net > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: > > > php-list-admin@lists.php.net > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: > > > php-list-admin@lists.php.net > > > > > > >-- > >PHP Database Mailing List (http://www.php.net/) > >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > >For additional commands, e-mail: php-db-help@lists.php.net > >To contact the list administrators, e-mail: > php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net