FUDforum: comp.lang.php » transfering all MySQL rows to an array

Home » Imported messages » comp.lang.php » transfering all MySQL rows to an array

Show: Today's Messages :: Polls :: Message Navigator

Re: transfering all MySQL rows to an array [message #176505 is a reply to message #176502]

Sun, 08 January 2012 19:04

Gregor Kofler
Messages: 69
Registered: September 2010

Karma:

Member

Am 2012-01-08 19:56, M. Strobel meinte:
> Am 08.01.2012 19:28, schrieb Gregor Kofler:
>>>
>>> PDO is an abstraction layer, but only at the call level. This is
>>> better than none.
>>
>>
>>> I think people only talking about mysql are thinking small. You
>>> should not give away flexibility when it comes at small cost.
>>
>> I know what PDO does. And does not. Flexibility is quite limited. Take a
>> query with a LIMIT clause and try to execute it on a MSSQL server. Or
>> dealing with date data. IOW: Unless you stick to (really) simple CRUD
>> queries, the additional abstraction layer of PDO won't add an awful lot
>> of flexibility. Agreed, the interface won't change when switching databases.
>>
>>> Small cost: the alleged performance of PDO is rather my
>>> experience. Additionally the web search turned up in the first hits:
>>> http://www.el-bato.de/it/php-mysql-vs-mysqli-vs-pdo-performance
>>> (sorry, in german)
>>
>> I doubt that with your average web application the execution time of db
>> calls will be a problem at all. Proper db design, indexing and effort
>> put into optimizing the queries themselves will yield much more
>> performance gain. (The above benchmarks show that the impact of PDO is
>> little with basic queries. How about memory consumption, will the
>> benchmarks hold with all data types, etc?)
>>
>>> Before we start discussing benchmarks I would like to know: what
>>> especially do you not like about it?
>>
>> You stating "the overhead is minimal due to the fact it is a compiled
>> extension". Just being a compiled extension doesn't say anything about
>> performance penalties (or lack thereof).
>>
>> Gregor
>
> compiled extension in C vs. extension in PHP.

I'm not aware of extensions written in PHP. You could have classes or a
framework written in PHP.

Gregor

Report message to a moderator

[Message index]

		transfering all MySQL rows to an array By: bill on Sat, 07 January 2012 20:03
		Re: transfering all MySQL rows to an array By: Luuk on Sat, 07 January 2012 20:53
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 01:06
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 13:54
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sun, 08 January 2012 14:12
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 00:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 08:55
		Re: transfering all MySQL rows to an array By: Norman Peelman on Mon, 09 January 2012 11:59
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 12:05
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:47
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Sat, 07 January 2012 21:07
		Re: transfering all MySQL rows to an array By: bill on Sun, 08 January 2012 11:49
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:00
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 17:33
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 17:57
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 18:28
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:56
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 19:04
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 23:07
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 00:02
		Re: transfering all MySQL rows to an array By: Erwin Moller on Mon, 09 January 2012 09:58
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 10:09
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 10:27
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:41
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:24
		Re: transfering all MySQL rows to an array By: Luuk on Mon, 09 January 2012 12:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 10:32
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Mon, 09 January 2012 12:30
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 12:45
		Re: transfering all MySQL rows to an array By: Arno Welzel on Sun, 08 January 2012 19:31
		Re: transfering all MySQL rows to an array By: Gregor Kofler on Sun, 08 January 2012 21:43
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 18:22
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:05
		Re: transfering all MySQL rows to an array By: Peter on Sun, 08 January 2012 17:56
		Re: transfering all MySQL rows to an array By: Denis McMahon on Sun, 08 January 2012 09:39
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Sun, 08 January 2012 10:31
		Re: transfering all MySQL rows to an array By: M. Strobel on Sun, 08 January 2012 14:02
		Re: transfering all MySQL rows to an array By: Denis McMahon on Mon, 09 January 2012 00:18
		Re: transfering all MySQL rows to an array By: Thomas 'PointedEars' on Mon, 09 January 2012 01:02
		Re: transfering all MySQL rows to an array By: Jerry Stuckle on Mon, 09 January 2012 03:02
		Re: transfering all MySQL rows to an array By: M. Strobel on Mon, 09 January 2012 09:06

Previous Topic:	sessions timeout
Next Topic:	scoping inside a block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:00:24 GMT 2024

Total time taken to generate the page: 0.05196 seconds