Re: Prep. Statements only in mysql-i? [message #177672 is a reply to message #177669] |
Thu, 12 April 2012 18:08 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 4/12/2012 1:28 PM, M. Strobel wrote:
> 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.
>
The mysql interface has nothing to do with the old mysql password
format. Two entirely different things.
The fact is that mysql_xxx is faster and generally easier to use in a
procedural script. mysqli_xxx is slower, but easier to use in an OO format.
Both have advantages and disadvantages, and should be used as appropriate.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|