Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!news-1.dfn.de!news.dfn.de!news.informatik.hu-berlin.de!fu-berlin.de!uni-berlin.de!not-for-mail From: "M. Strobel" Newsgroups: comp.lang.php Subject: Re: Prep. Statements only in mysql-i? Date: Thu, 12 Apr 2012 19:28:13 +0200 Lines: 42 Message-ID: <9uohldF1pgU1@mid.uni-berlin.de> References: <539265724355876611.335360herzog.alex-arcor.de@individual.de> <9unpbiF83dU1@mid.uni-berlin.de> <9uoa8qF8p1U1@mid.uni-berlin.de> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de Vvd1PxJsw7LxuFJb9i/c+Q3RBYjALlNs47QHeaNjYOqR6kLdU= User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.2.28) Gecko/20120306 Thunderbird/3.1.20 In-Reply-To: Xref: csiph.com comp.lang.php:5498 Am 12.04.2012 19:16, schrieb Jerry Stuckle: > On 4/12/2012 11:22 AM, M. Strobel wrote: >> Am 12.04.2012 13:51, schrieb Jerry Stuckle: >>> On 4/12/2012 6:33 AM, M. Strobel wrote: >>>> Am 12.04.2012 00:42, schrieb Alexandra Herzog: >>>> >>>>> but my hoster only offers mysql >>>> >>>> It makes me angry to hear this. The mysql drivers were outdated long before the >>>> makers stopped supporting it in 2006. >>>> >>>> /Str. >>> >>> MySQL not supported? Who says? It's the most commonly used database on the web. >>> PostgreSQL and others are way behind in popularity (although I won't get into an >>> argument as to which is "better"). >>> >>> Or if you mean the mysql interface vs. mysqli, who says it isn't supported? >> >> mysql interface vs. mysqli. I know the first is old and slower, and the support info >> I just read at http://www.radicore.org/radicore-for-php.php >> >> /Str. >> > > And how do you "know" that? Both end up as calls to mysql_xxxx C functions. The > mysql_xxx calls in PHP are just wrappers to the C functions. The mysqli_xxx calls > have to do a lot more work before calling the appropriate mysql_xxx C functions. > > If the mysqli_xxx calls have to do more work before calling the same functions, how > can they be faster? I admit my arguments are a bit sloppy, one could go more into depth. But true is that mysqli is strongly recommended for MySQL versions 4.1.3 or later, see http://ca3.php.net/manual/en/mysqli.overview.php And I can't understand why the mysql interface is still advocated by some. Look at the old mysql password format, ridiculous. /Str.