Re: PHP can't lose to Micro$oft - Please HELP!

Here's what ya do.. "Hey boss..I did a little checking, and it turns out MySQL *isnt* free. Sure, you can download it and install it for free, yeah, but you have to pay for tech support apparently. No, really! When you have a problem ya send an email to this mailing list they have, and whoever answers with the right answer, you have to pay em $10." =) Everyone's happy! =) When I started, I went for the popularly-known database too. But in my case, I'd never heard of PostgreSQL, and I thought Oracle was some kinda programming language or something. =) I gues my own lack of knowledge worked out to my advantage. =) Helge A. Kraenz (FF) wrote: > I have to agree - sad but true. > > The main problem is that MySQL is more or less free. So they don't have much > money to spend for any marketing purposes. The decision of what product will > be used is never made because of facts (being more precise: was never and > will never be made), use your imagination what are the real reasons. This is > frustrating but maybe I'm only jealous that I cannot make decisions ;-) It's > the same with MS: Why should you use MS in a company? Use Linux/Star Office > and be happy! > > Helge > > > -----Original Message----- > > From: Lars B. Jensen [mailto:ljweb@ljweb.com] > > Sent: Donnerstag, 11. Oktober 2001 08:23 > > 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 > > > > -- > 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 -- - Tim PHP Galaxy: http://www.phpgalaxy.com/ The LavaWarp Engine: http://www.phpgalaxy.com/engine.php3 BitSearch: http://www.phpgalaxy.com/bitsearch.php3 MetaWarp: http://www.phpgalaxy.com/metawarp.php3 PhotoRate: http://www.phpgalaxy.com/photorate.php3 Earn $10 per order selling these scripts on your site! http://www.phpgalaxy.com/aff/