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

so very true especially government departments - there is no investigation into performance etc etc the purchasing process is something like; "what's the most known product available?" "Oracle" "is it expensive?" "very much so sir" "buy 5 of them" :P and then... "how about postgresql sir? it's free and will more than work for our requirements" "free? - but we have a budget..." "we can save money sir" "customers want to see where we spent the dollars boy, and they want recognised names... get us 5 of those oracle thing-o's" :P /beau // -----Original Message----- // From: Lars B. Jensen [mailto:ljweb@ljweb.com] // Sent: Thursday, 11 October 2001 2:23 PM // To: Helge A. Kraenz (FF); 'Jason G.'; 'Dave Watkinson'; // php-db@lists.php.net // Subject: 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 // // // // // // -- // 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 //